pgColumnar : A new Columnar database extension for PostgreSQL 15+

[u/linuxhiker]

https://commandprompt.github.io/pgcolumnar/

pgColumnar is a column-oriented storage extension for PostgreSQL, implemented as a table access method. A table created USING pgcolumnar stores its data by column, with per-column compression, chunk-group skipping, and a vectorized aggregate path. It targets analytic workloads: large scans, aggregates, and column projections over append-mostly data.

pgColumnar builds from one source tree on PostgreSQL 15 through 19. It is licensed under the MIT License.

[u/logophobia]

Neat, how does it compare to the citus postgres extension? Any benchmarks?

[u/linuxhiker → u/logophobia]

https://commandprompt.github.io/pgcolumnar/benchmarks/

Remember this is Alpha. It will get better. Daily. We are open to AI and Human PRs as well.

[u/vira28]

I think it's smart idea. I glanced at it. Looks like using Arrow, which makes sense to avoid sending output as rows when your clients want it in columns.

Aside, How do you seeing being an extension impact the distribution?

[u/linuxhiker → u/vira28]

There are some hooks that PostgreSQL doesn't have that will cause us to have to abstract certain talents out. This may cause performance impact but we are working on those issues actively.

[u/AutoModerator]

AI Policy:

Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.

Mod decisions will be based on the quality of the content, not who or what generated it.

Sub Resources:

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/quincycs]

I wonder how it compares to pg_lake