Consider adding the Citus extension #92

Activity

1. seajhawk commented on Dec 5, 2022

   

   seajhawk

   on Dec 5, 2022

   Last edited by seajhawk

   More actions

   I'd love to see you add the Citus extension as well, but for a different reason.

   I'm using Postgres for reporting with Metabase and I want to minimize my storage needs. Citus has adds support for columnar compression.

   I realize that I could fork this repo and add it on my own, but the capabilities of Citus are something that benefit a large percentage of folks, and TBH as a one-man-show I already have plenty on my plate. :)
2. davissp14 commented on Dec 5, 2022

   

   davissp14

   on Dec 5, 2022

   Last edited by davissp14

   Contributor

   More actions

   I'm not totally sure Citus will work with Stolon. If someone wants to try and put together a POC, I think that would be useful.
3. viggy28 commented on Feb 18, 2023

   

   viggy28

   on Feb 18, 2023

   More actions

   On a high level, though citus is a Postgres extension it has nuances.

   1. There are nodes with specific roles - Co-ordinator & Workers
   2. It has distributed query planner and executor - Meaning it will be likely doing query rewrites and has metadata on which worker to send specific parts of a query
   3. FWIW, citus uses pg_auto_failover for node failures.

   Unfortunately, stolon isn't aware of any of these.