Postgres Just Cracked the Top Fastest Databases for Analytics

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by dsiegel2275 on Saturday March 08, 2025 @08:29AM (#43300104)

A question that I have had for a while that I can't seem to find an answer: for teams that are using various columnar store extensions to turn Postgres into a viable OLAP solution - are they doing so in the same instance of their Postgres that they are using for OLTP? Or are they standing up a separate Postgres instance?

I'm trying to understand if there is any potential performance impact on the OLTP workload by including the OLAP in the same process.

[ Parent | on HN ]

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by bach4ants on Saturday March 08, 2025 @08:52AM (#43300251)

And further, with this pg_mooncake extension allowing you to store the data in S3, is Postgres simply providing compute to run DuckDB? I suppose it's also providing a standardized interface and "data catalog."

[ Parent | on HN ]

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by zhousun on Saturday March 08, 2025 @10:48AM (#43301080)

transactions are also managed by postgres as if they are native table, so that you don't need to worry about coordinating commits between postgres and the S3 data.

[ Parent | on HN ]