Hacker News Reader

clairegiordanoon Citus 11 for Postgres goes fully open source, with query from any node

I had just replied to @simonw's comment about users with links to some blog posts & talks, and unfortunately now that this was made dupe, it appears the comment thread is truncated/removed? I suppose my only choice is to reach out to Simon on another platform to answer?

+1 on Jelte's sentiment, Marco's blog post about Citus 11 covered much more perspective and shared many more details than in the commit that was shared previously.

clairegiordanoon Make enterprise features open source

I'm not a user per se Simon, but I work on the Citus team and can share links to a few customer stories.

+ Implementation of the UK Coronavirus Dashboard running on Citus and Postgres, a post co-authored by the technical lead of the dashboard, Pouria Hadjibagheri: https://www.citusdata.com/blog/2021/12/11/uk-covid-19-dashbo...

+ Architecting petabyte scale analytics using Postgres and Citus, based on an interview with the user, Min Wei: https://www.citusdata.com/blog/2019/12/07/petabyte-scale-ana...

+ Video of a customer talk about scaling a SaaS application on Citus by Jonathan Denney at ConvertFlow: https://youtu.be/PzGNpaGeHE4

clairegiordanoon Make enterprise features open source

Pronounced as site-us (or sight-us, as in "eyesight")

Side-note, I had a bit of fun with the pronunciation & spelling challenges of working on Postgres and Citus here: https://twitter.com/clairegiordano/status/150378415161432064...

clairegiordanoon An update of 455 new words

I can't seem to find the complete list online either, I just tweeted at the @MerriamWebster account to find out, we'll see if they share a link. Does anybody else have it?

clairegiordanoon Citus 10 brings columnar compression to Postgres

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.

clairegiordanoon Making Postgres stored procedures 9X faster in Citus

As ozgune just said: yes, that's right. The 9X is a comparison of how Postgres stored procedures in Citus 9.4 perform vs. in Citus 8.3 (as measured by the HammerDB benchmark, shown in Figure 5.)

When I read this post, I find the HammerDB TPROC-C benchmark results in Figure 1 to be super interesting, too. When you compare Citus 9.4 performance with distributed tables and distributed functions vs. Citus 9.4 with regular Postgres tables and regular Postgres functions (on a single node) -- then the multiplier is an even more impressive ~19X. :)

clairegiordanoon What's new in the Citus 9.5 extension to Postgres

OA here: we hope you do. :)

There's a Citus Public Slack for q&a, and a pretty useful Citus technical newsletter to stay informed (monthly) about what's new.

clairegiordanoon Evolving pg_cron together: Postgres 13, audit log, background workers, job names

So pg_cron is a useful job scheduler and it's true that so many Postgres people use it & appreciate it... But the part I like best about this new 1.3 version of pg_cron is the bit about the open source collaboration between Microsoft and the RDS team and Zalando.

This is how open source should be done.