[slackerIII]

What would it take for something like this to make it into Postgres?

[VHRanger]

unlikely - postgres stores data row-wise and this assumes sequentially stored columns. They even mention that issue in the blog post.

It would be more likely to show up in something like Apache Arrow which is designed columnar to leverage these sort of tricks

[samwillis]

There are various Postgres extensions (such as Citus) that are columnar, so with them it should be possible.

[noisy_boy]

How about AWS Redshift which is columnar (though that is also based on Postgres)...

[Denvercoder9]

The data in indexes is stored columnar by most RDBMSes, as far as I know.

[wenc]

Typically a rowstore index is a B-tree data structure (on a column) that points to data pages in a rowstore dataset.

It's not technically columnar as such.

You can sort with a rowstore index today, but I imagine you have to materialize the index in some way to take advantage of vectorization.

[janwas]

I don't know about "most", but here is a list: https://en.wikipedia.org/wiki/List_of_column-oriented_DBMSes

[ComputerGuru]

No, this is a list of columnar database systems - gp was saying the index, which is often (but not always) stored separately from the main db records.

[janwas]

Ah, indeed, my mistake. FWIW I've observed increasing numbers of papers over the past couple of years mentioning entirely columnar databases.

[kjeetgill]

I mean, I guess you could call a B-Tree over a subset of columns "columnar"... And bit-map indexes are by columns too — but that's really bending the definition of what most people mean by columnar storage in databases.

[ddorian43]

It actually is not.

[polskibus]

See commment: https://news.ycombinator.com/item?id=31624451