Hacker GitHub

← All repos

citusdata/citus

View on GitHub ↗ ★ 12,840 C

Distributed PostgreSQL as an extension

54 mentions on Hacker News by 36 people: 7 stories, 47 comments · first 2016-03-24 · latest 2025-09-22

Mentions per year 54 mentions · busiest year 2017 (11)
20082026
AllStoriesComments NewestTopOldest
  1. Will Neki be a branch of [Citus]( https://github.com/citusdata/citus ) or is it more based on Vitess?
    comment by sethreno · 2025-09-22 · in PlanetScale for Postgres is now GA
  2. …of focusing just on "hypertables" which necessarily must have a time column as primary key. [1] https://github.com/citusdata/citus?tab=readme-ov-file#creati...
    comment by giovannibonetti · 2025-03-29 · in New open-source benchmark for real-time analytics applications
  3. for one thing, depending on your licensing contraints: - Citus is AGPLv3 https://github.com/citusdata/citus/blob/v13.0.1/LICENSE - Hydra is Apache 2 https://github.com/hydradatabase/columnar/blob/v1.1.2/LICENS... - Timescale is mostly…
    comment by mdaniel · 2025-02-23 · in Reliably replicating data between Postgres and ClickHouse
  4. …and I imagine it could be compressed at least 10x compared to regular JSON or JSONB columns. [1] https://github.com/citusdata/citus?tab=readme-ov-file#creati... [2] https://cloud.google.com/sql/docs/postgres/extensions
    comment by giovannibonetti · 2024-12-30 · in Short Message Compression Using LLMs
  5. Horizontal scale of writes. Citus would be alright if the HA story was better: https://github.com/citusdata/citus/issues/7602
    comment by geenat · 2024-08-17 · in Just use Postgres
  6. Citus gets close for many usecases but the HA story sucks: https://github.com/citusdata/citus/issues/7602
    comment by geenat · 2024-08-15 · in CockroachDB license change
  7. Citus would be great if the HA story was better: https://github.com/citusdata/citus/issues/7602
    comment by geenat · 2024-08-15 · in CockroachDB license change
  8. …/ https://github.com/CrunchyData/postgres-operator [3] https://www.citusdata.com / https://github.com/citusdata/citus
    comment by sea-gold · 2024-05-29 · in Show HN: Serverless Postgres
  9. for one thing: https://github.com/pg-sharding/spqr/blob/1.3.0/LICENSE (BSD2) https://github.com/citusdata/citus/blob/v12.1.2/LICENSE (AGPLv3)
    comment by mdaniel · 2024-03-25 · in SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL
  10. I see they don't mention Citus ( https://github.com/citusdata/citus ), which is already a fairly mature native Postgres extension. From the details given in the article, it sounds like they just reimplemented it. I wonder if they were…
    comment by adastral · 2024-03-14 · in How Figma's databases team lived to tell the scale
  11. …for something like this for postgres I came across citus. Any one know how that stacks up? https://github.com/citusdata/citus
    comment by getcrunk · 2023-11-07 · in Vitess 18
  12. Citus: https://github.com/citusdata/citus BTW, Citus license is GNU Affero General Public License (github lists “conditions: same license”) and hydra is Apache. How is that possible if the latter is a fork? There’s probably something about…
    comment by thih9 · 2023-08-03 · in Show HN: Hydra 1.0 – open-source column-oriented Postgres
  13. https://github.com/citusdata/citus
    comment by gardenfelder · 2023-07-31 · in Schema-based sharding comes to PostgreSQL with Citus
  14. Not really. It's comparable to a regular Postgres upgrade. But you can screw it up - see https://github.com/citusdata/citus/discussions/6934
    comment by krab · 2023-07-19 · in Citus 12: Schema-based sharding for PostgreSQL
  15. …https://aws.amazon.com/s3/pricing/ [2]: https://github.com/Logflare/logflare_logger_backend [3]: https://github.com/citusdata/citus [4]: https://github.com/timescale/timescaledb edit: Ah looks like Chase answered as well :)
    comment by lyziinc · 2023-04-11 · in Supabase Logs: open-source logging server
  16. …[1] might allow you stay within the PostgreSQL ecosystem even when you are trying to do OLAP. [1] https://github.com/citusdata/citus
    comment by martintietz · 2022-12-10 · in Just use Postgres for everything
  17. Agree. Here is a list of the limitations: https://github.com/citusdata/citus/tree/main/src/backend/col...
    comment by martintietz · 2022-12-10 · in Just use Postgres for everything
  18. …in the same breath as "Much respect" for Citus here. ---------------------------------------- [1] https://github.com/citusdata/citus/blob/master/LICENSE
    comment by quadrifoliate · 2022-06-17 · in Make enterprise features open source
  19. …citus[1], the company behind this extension has been acquired by Microsoft two years ago[2]. [1]: https://github.com/citusdata/citus [2]: https://blogs.microsoft.com/blog/2019/01/24/microsoft-acquir...
    comment by ghassanmas · 2022-01-23 · in The implementation of the UK Covid-19 dashboard
  20. …be changed and may have more rows than this maximum value. The default value is 10000." read more: https://github.com/citusdata/citus/tree/master/src/backend/c...
    comment by pella · 2021-11-08 · in The LZ4 introduced in PostgreSQL 14 provides faster compression
  21. …I was talking about. As far as open-source add-ons for true horizontal scaling, I think [Citus]( https://github.com/citusdata/citus ) is the most well-known and sophisticated, but I don't have enough experience with it in production to…
    comment by GeneralMayhem · 2021-09-06 · in Ask HN: What could a modern database do that PostgreSQL and MySQL can't
  22. …and on columnar compression. :-) I am waiting for the basic index support for columnar tables ! https://github.com/citusdata/citus/pull/4950 :-)
    comment by pella · 2021-05-30 · in PolarDB, yet another open source database system based on PostgreSQL
  23. …Postgres extension that adds both distributed database capabilities and columnar storage. :) https://github.com/citusdata/citus (Citus engineer)
    comment by mslot · 2021-05-30 · in PolarDB, yet another open source database system based on PostgreSQL
  24. Citus, cited at the end, is a column store (single node or distributed) https://github.com/citusdata/citus
    comment by BenoitP · 2021-05-10 · in Using PostgreSQL as a Data Warehouse
  25. …on tuning out database to keep up! As your using postgres have you looked at citus[0] at all? [0] https://github.com/citusdata/citus
    comment by whycombagator · 2021-03-09 · in Write libraries instead of services, where possible
  26. Citus Data extension can help you scale horizontally. https://github.com/citusdata/citus
    comment by truth_seeker · 2019-10-03 · in PostgreSQL 12
  27. …general. I also believe that the practices around PRs and code reviews are also good examples. [1] https://github.com/citusdata/citus
    comment by aamederen · 2019-07-30 · in Ask HN: What are the “best” codebases that you've encountered?
  28. Citus extension: https://github.com/citusdata/citus
    comment by truth_seeker · 2019-05-09 · in PostgreSQL 11.3 and 10.8
  29. https://github.com/citusdata/citus
    comment by Matrixik · 2018-10-25 · in MongoDB's Server Side Public License Is Likely Unenforceable
  30. …make it work in that setting. If Postgres works well in that setting why do things like this exist? https://github.com/citusdata/citus
    comment by jazoom · 2018-06-12 · in Gitlab 500 error
  31. …to rewrite queries. Can an extension even add syntax? EDIT: This seems to be the important part: https://github.com/citusdata/citus/blob/master/src/backend/d... I wonder what `planner_hook` is about. . . .
    comment by pjungwir · 2017-10-06 · in PostgreSQL 10 Released
  32. citus is all opensource now - https://www.citusdata.com/blog/2016/03/24/citus-unforks-goes... https://github.com/citusdata/citus Which is why Postgres is creeping up on both scylladb and cassandra. Plus PG 10 will have declarative…
    comment by sandGorgon · 2017-09-26 · in Why SQL is beating NoSQL, and what this means for the future of data
  33. …been adding features to make app integration seamless. With our upcoming release, we'll get there: https://github.com/citusdata/citus/issues/595
    comment by ozgune · 2017-08-10 · in Principles of Sharding for Relational Databases
  34. Citus should be marked as Open Source as well: https://github.com/citusdata/citus
    comment by Artemis2 · 2017-05-23 · in A comparison of advanced, modern cloud databases
  35. …to leverage upcoming partitioning improvements in Postgres 10 and further automate this setup: https://github.com/citusdata/citus/issues/183 For more on Citus + cstore, this recent HN comment could also be helpful:…
    comment by ozgune · 2017-04-06 · in Distributed count(distinct) with HyperLogLog on Postgres
  36. …(distributed db) and cstore_fdw (columnar storage) has been one of the most requested features: https://github.com/citusdata/citus/issues/183 (2) High-availability & disaster recovery: This requires that cstore integrates with PG's…
    comment by ozgune · 2017-04-05 · in Building a scalable time-series database on PostgreSQL
  37. …though as you have to deploy the function to each table. They offer a script to help you with it https://github.com/citusdata/citus/blob/a2f6b29a6d4537b626f8... - You do want to consider how many shards you need. More automatically means…
    comment by doh · 2017-02-17 · in Citus 6.1 Released – Horizontally scale your Postgres database
  38. …to the related shards. With this release, we run this command in parallel across worker nodes. ( https://github.com/citusdata/citus/issues/719 ) [1] Citus' user-defined functions aren't in the public, but rather in the pg_catalog schema.…
    comment by ozgune · 2017-02-16 · in Citus 6.1 Released – Horizontally scale your Postgres database
  39. Citus ( https://github.com/citusdata/citus ) is pretty easy to use for distributed postgres.
    comment by kod · 2017-02-06 · in RethinkDB Relicensed under Apache 2.0
  40. Comparison Request: Citus ( https://github.com/citusdata/citus )
    comment by aamederen · 2017-01-02 · in TiDB – A distributed NewSQL database compatible with MySQL protocol
  41. (Ozgun from Citus Data) We're planning on supporting VIEWS (but not MATERIALIZED VIEWs) in Citus 6.1: https://github.com/citusdata/citus/issues/442 If you're interested in using Materialized Views in Citus, please feel free to comment on…
    comment by ozgune · 2016-11-29 · in Real-time event aggregation at scale using Postgres with Citus
  42. Citus is Open Sourced since "Mar 2016", so it is not so old. https://github.com/citusdata/citus/blob/release-5.1/CHANGELO... "citus v5.0.0 (March 24, 2016) - Public release under AGPLv3 - PostgreSQL extension compatible with PostgreSQL 9.5…
    comment by pella · 2016-07-26 · in Why Uber Engineering Switched from Postgres to MySQL
  43. …==== And "Scalable PostgreSQL for real-time workloads https://www.citusdata.com " --> https://github.com/citusdata/citus
    comment by pella · 2016-07-26 · in Why Uber Engineering Switched from Postgres to MySQL
  44. …& Open Source PostgreSQL extension https://www.citusdata.com ( based on PG9.4 / PG9.5 ) Github: https://github.com/citusdata/citus HN: https://news.ycombinator.com/item?id=11353322 "Citus Unforks from PostgreSQL, Goes Open Source…
    comment by pella · 2016-03-26 · in Analytics 101: Choosing the right database
  45. …that we receive: https://news.ycombinator.com/item?id=11353866 If we go with the approach in https://github.com/citusdata/citus/issues/389 , you will be able to configure #3, #6, #7 through PostgreSQL's streaming replication settings. We…
    comment by ozgune · 2016-03-24 · in Citus Unforks from PostgreSQL, Goes Open Source
  46. …primary challenge is set-up complexity. We're now prototyping one of those designs to know more: https://github.com/citusdata/citus/issues/389 We expect to share all the details and a concrete timeline in April.
    comment by ozgune · 2016-03-24 · in Citus Unforks from PostgreSQL, Goes Open Source
  47. AGPL license if anyone's curious: https://github.com/citusdata/citus/blob/master/LICENSE
    comment by exhilaration · 2016-03-24 · in Citus Unforks from PostgreSQL, Goes Open Source