News for hackers. Stuff that matters.

A comment on Tell HN: Citus is 100% open source now. Parent comment

Re:Tell HN: Citus is 100% open source now by pcthrowaway on Friday September 02, 2022 @02:23PM (#32694131)
That's how every Postgres extension works (e.g. Timescale, PostGIS, etc.)
[ Parent | on HN ]
Re:Tell HN: Citus is 100% open source now by firloop on Friday September 02, 2022 @02:33PM (#32694254)
Not just Postgres extensions, most of Postgres’ own administrative functions can be triggered in SELECT statements. e.g. pg_terminate_backend()

https://www.postgresql.org/docs/current/functions-admin.html

[ Parent | on HN ]
Re:Tell HN: Citus is 100% open source now by yjftsjthsd-h on Saturday September 03, 2022 @12:28PM (#32703449)
To be quite clear, that always felt weird to me as well - something to the effect of "I thought SELECT was for reading data; why am I using it to create a replica?"
[ Parent | on HN ]