We built our customer data warehouse all on Postgres

Re:We built our customer data warehouse all on Postgres by KptMarchewa on Friday February 02, 2024 @04:29AM (#39226820)

I generally agree. I think one case that it weren't true was LISTEN/NOTIFY https://www.postgresql.org/docs/current/sql-notify.html - the API is actually simple and well tested.

[ Parent | on HN ]

Re:We built our customer data warehouse all on Postgres by fuy on Friday February 02, 2024 @10:02AM (#39229347)

and doesn't scale well. Meaning using it can take your Postgres server down way before regular SQL workload would.

[ Parent | on HN ]

Re:We built our customer data warehouse all on Postgres by justinclift on Saturday February 03, 2024 @02:29AM (#39238233)

Note that LISTEN/NOTIFY isn't compatible with 2 phase commit though, which can potentially rule out its use in some situations.

[ Parent | on HN ]