News for hackers. Stuff that matters.
Re:Implement table partitioning by MarHoff on Thursday December 08, 2016 @10:00AM (#13130650)
Maybe I don't get you, but i don't think so, PostgreSQL is not a columnar database.

If i got this patch right, each partitioned table will have the same data structure and store whole rows (it's even more restrictive than previous inheritance mechanism that allowed extending by adding additional columns).

Column or expression should only define in which table an inserted row is supposed to be stored. A single row will never been torn apart. Still it look like a foundation that facilitate sharding BigData(Set) between multiple servers when used in conjunction with foreign data. However a lot of performance improvements will still be needed to compete against solid NoSQL projects (in which you really have a BigData use case).

But looking a bit forward, developing performances improvements on top of an ACID compliant distributed database seems less difficult than to develop a NoSQL project for it to become ACID.

Re:Implement table partitioning by spacemanmatt on Thursday December 08, 2016 @12:29PM (#13132106)
Generally PostgreSQL is a row database but Citus has release column drivers that make it perform similar to other columnar databases.

But this patch is about horizontal partitions.