News for hackers. Stuff that matters.
Re:Citus 10 brings columnar compression to Postgres by nwatson on Saturday March 06, 2021 @02:28PM (#26369814)
Sensage/Addamark was too early to the columnar storage game in 2001-2003 ... https://en.wikipedia.org/wiki/Sensage.
Re:Citus 10 brings columnar compression to Postgres by atombender on Saturday March 06, 2021 @04:28PM (#26370669)
Sybase/IQ (now SAP IQ, originally acquired from Expressway) was launched in 1995.

There are other old column databases, such as kdb, but I believe Sybase/Expessway was the first commercial product.

Re:Citus 10 brings columnar compression to Postgres by jacques_chester on Saturday March 06, 2021 @02:57PM (#26370036)
I think the claim here is that Citus added it to PostgreSQL.

Depending on how one defines that claim, Greenplum may have been first.

Disclosure: I work for VMware, which sponsors Greenplum development.

Re:Citus 10 brings columnar compression to Postgres by clairegiordano on Saturday March 06, 2021 @03:14PM (#26370183)
Definitely not intending to take credit away from any other teams. There are so many good Postgres extensions and forks in this ecosystem.

What we've done is add a Columnar storage feature into the Citus open source extension to Postgres, as part of Citus 10.

One way to think of it: Citus 10 now gives Postgres users (those who are also using the Citus extension) a columnar compression option, for use on a single node and/or a distributed Citus cluster.

Re:Citus 10 brings columnar compression to Postgres by jacques_chester on Saturday March 06, 2021 @04:44PM (#26370801)
Thanks. Regardless of who did what, columnar stores are non-trivial engineering and anyone who produces a production-ready one is worthy of admiration.
Re:Citus 10 brings columnar compression to Postgres by asah on Saturday March 06, 2021 @03:29PM (#26370283)
Greenplum was founded in 2003, A/S was 2001.
Re:Citus 10 brings columnar compression to Postgres by jacques_chester on Saturday March 06, 2021 @04:42PM (#26370785)
Again, my qualifier is "to PostgreSQL". I couldn't see such a connection on a brief skim of the A/S wikipedia entry.
Re:Citus 10 brings columnar compression to Postgres by mcrutcher on Saturday March 06, 2021 @06:14PM (#26371416)
I was the PM for the software side of Greenplum DB for a while. I also don't know of an earlier example of a separate column oriented storage option on top of a Postgres base. Vertica and ParAccel (which became Redshift) both also started from a Postgres base (though Vertica claims otherwise in marketing material) but were a little later. In any case, "Column oriented storage for Postgres" is almost 20 years old. This also isn't the first open source implementation.
Re:Citus 10 brings columnar compression to Postgres by asah on Sunday March 14, 2021 @06:57AM (#26454307)
Nice to meet you :-)

You're right that Addamark wasn't open source and wasn't a storage option, but it was indeed built with a Postgres base.

Here's the paper (2002):

https://www.usenix.org/legacy/events/lisa2002/tech/full_pape...

There were non-Postgres SQL columnar stores as well, most notably Sybase IQ, which dates to the 1990s: https://en.m.wikipedia.org/wiki/SAP_IQ