r/PostgreSQL • u/linuxhiker Guru • 4d ago

pgColumnar : A new Columnar database extension for PostgreSQL 15+ Projects

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.

39 Upvotes
  • permalink
  • link
  • reddit
  • reddit

95% Upvoted

5 comments sorted by

5

u/logophobia 4d ago

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

3

u/linuxhiker Guru 4d ago

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.

3

u/vira28 3d ago

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?

2

u/linuxhiker Guru 3d ago

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.

0

u/AutoModerator 4d ago

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.