Hacker News
- Scaling out Postgres with the Citus open source shard rebalancer https://www.citusdata.com/blog/2021/03/13/scaling-out-postgres-with-citus-open-source-shard-rebalancer/ 4 comments
- Citus 10 brings columnar compression to Postgres https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-compression-for-postgres/ 58 comments
- Citus 7.2: Distributed Postgres with CTEs, complex subqueries, set operations https://www.citusdata.com/blog/2018/01/26/citus-7-2-ctes-complex-subqueries-set-operations/ 2 comments
- Distributed count distinct vs. HyperLogLog in Postgres https://www.citusdata.com/blog/2017/12/22/distributed-count-vs-hyperloglog/ 11 comments
- How Citus Executes Distributed Transactions on Postgres https://www.citusdata.com/blog/2017/11/22/how-citus-executes-distributed-transactions/ 15 comments
- Postgres Count Performance https://www.citusdata.com/blog/2016/10/12/count-performance?source=pg_weekly 31 comments
- CitusDB 4.0, pg_shard 1.1, and cstore 1.2 are out. What's next? https://www.citusdata.com/blog/149-whats-next 8 comments
- PostgreSQL Columnar Store for Analytic Workloads http://www.citusdata.com/blog/76-postgresql-columnar-store-for-analytics 57 comments
- Running PostgreSQL on Compression-enabled ZFS http://citusdata.com/blog/64-zfs-compression 56 comments
Lobsters
- Citus 11 for Postgres goes fully open source https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/ 4 comments databases , distributed
- Fun with SQL: Functions in Postgres https://www.citusdata.com/blog/2018/06/21/fun-with-sql-functions/ 2 comments databases
- When Postgres blocks: 7 tips for dealing with locks https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/ 2 comments databases
- Podyn: DynamoDB to PostgreSQL replication and migration tool https://www.citusdata.com/blog/2017/09/22/dynamodb-to-postgres-replication/ 2 comments databases
- Five ways to paginate in Postgres, from the basic to the exotic https://www.citusdata.com/blog/2016/03/30/five-ways-to-paginate/ 4 comments databases
- Sharding a multi-tenant app with Postgres https://www.citusdata.com/blog/2016/08/10/sharding-for-a-multi-tenant-app-with-postgres/ 2 comments databases
- Faster PostgreSQL Counting https://www.citusdata.com/blog/2016/10/12/count-performance/ 2 comments databases
- Citus Unforks From PostgreSQL, Goes Open Source https://www.citusdata.com/blog/17-ozgun-erdogan/403-citus-unforks-postgresql-goes-open-source 3 comments databases
- What's new in the Postgres 16 query planner / optimizer (cross post from r/postgresql) https://www.citusdata.com/blog/2024/02/08/whats-new-in-postgres-16-query-planner-optimizer/ 9 comments sql
- Announcing Citus 11.1: sharding your Postgres tables without interruption (cross post from r/postgresql) https://www.citusdata.com/blog/2022/09/19/citus-11-1-shards-postgres-tables-without-interruption/ 5 comments programming
- Distributed Postgres goes full open source with Citus: why, what & how (cross post from r/sql) https://www.citusdata.com/blog/2022/09/12/distributed-postgres-goes-full-open-source-with-citus/ 27 comments programming
- Citus 10 now generally available in Hyperscale (Citus) for Postgres on Azure https://www.citusdata.com/blog/2021/08/10/citus-10-is-now-ga-in-hyperscale-citus-for-postgres-on-azure/ 3 comments sql
- Citus Talk at CMU: Distributed PostgreSQL as an Extension https://www.citusdata.com/blog/2021/04/10/talk-at-cmu-how-citus-distributes-postgresql-via-extension-apis/ 9 comments postgresql
- Scaling out Postgres with the Citus open source shard rebalancer https://www.citusdata.com/blog/2021/03/13/scaling-out-postgres-with-citus-open-source-shard-rebalancer/ 2 comments postgresql
- Faster data migrations in Postgres https://www.citusdata.com/blog/2021/02/20/faster-data-migrations-in-postgres/ 6 comments sql
- When to use Hyperscale (Citus) to scale out Postgres (cross post from r/SQL) https://www.citusdata.com/blog/2020/12/05/when-to-use-hyperscale-citus-to-scale-out-postgres/ 3 comments programming
- Evolving pg_cron together: Postgres 13, audit log, background workers, & job names (cross post from r/SQL) https://www.citusdata.com/blog/2020/10/31/evolving-pg-cron-together/ 3 comments programming
- Why the RDBMS is the future of distributed databases https://www.citusdata.com/blog/2018/11/30/why-rdbms-is-the-future-of-distributed-databases/ 7 comments programming
- How Postgres is more than a relational database: Extensions https://www.citusdata.com/blog/2018/11/27/postgres-more-than-a-relational-database/ 33 comments programming
- Why Citus Data is donating 1% equity to PostgreSQL organizations https://www.citusdata.com/blog/2018/10/24/why-citus-data-is-donating-1-percent-equity/ 10 comments programming
- PostgreSQL 11 and Just In Time Compilation of Queries https://www.citusdata.com/blog/2018/09/11/postgresql-11-just-in-time/ 5 comments programming
- Postgres data types you should consider using https://www.citusdata.com/blog/2018/08/29/datatypes-you-should-consider-using/ 25 comments programming
- Fun with SQL: Common Table Expressions for more readable queries https://www.citusdata.com/blog/2018/08/09/fun-with-sql-common-table-expressions/ 34 comments programming
- It's the future (for databases) https://www.citusdata.com/blog/2018/05/08/its-the-future-for-databases/ 10 comments programming
- Database constraints in Postgres: The last line of defense https://www.citusdata.com/blog/2018/03/19/postgres-database-constraints/ 3 comments programming
- The Postgres 10 feature you didn't know about: CREATE STATISTICS https://www.citusdata.com/blog/2018/03/06/postgres-planner-and-its-usage-of-statistics/ 3 comments programming
- A tour of Postgres Index Types https://www.citusdata.com/blog/2017/10/17/tour-of-postgres-index-types/ 8 comments programming
- Five ways to paginate in Postgres, from the basic to the exotic https://www.citusdata.com/blog/2016/03/30/five-ways-to-paginate/ 4 comments programming
- Announcing Citus 5.2 https://www.citusdata.com/blog/2016/08/19/announcing-citus-52/ 5 comments programming
- Scaling PostgreSQL on Amazon RDS using pg_shard https://www.citusdata.com/blog/14-marco/178-scaling-out-postgresql-on-amazon-rds-using-masterless-pg-shard 6 comments programming
- New columnar datastore extension for PostgreSQL, supports compression and indexes http://citusdata.com/blog/76-postgresql-columnar-store-for-analytics 14 comments programming
Linking pages
- Why use Postgres (Updated for last 5 years) - Craig Kerstiens http://www.craigkerstiens.com/2017/04/30/why-postgres-five-years-later/ 370 comments
- Proposed server purchase for GitLab.com | GitLab https://about.gitlab.com/2016/12/11/proposed-server-purchase-for-gitlab-com/ 334 comments
- Microsoft acquires Citus Data, re-affirming its commitment to Open Source and accelerating Azure PostgreSQL performance and scale - The Official Microsoft Blog https://blogs.microsoft.com/blog/2019/01/24/microsoft-acquires-citus-data-re-affirming-its-commitment-to-open-source-and-accelerating-azure-postgresql-performance-and-scale/ 216 comments
- GitHub - cjbarber/ToolsOfTheTrade: Tools of The Trade, from Hacker News. https://github.com/cjbarber/ToolsOfTheTrade 202 comments
- Scaling the GitLab database | GitLab https://about.gitlab.com/2017/10/02/scaling-the-gitlab-database/ 131 comments
- How does database sharding work? https://planetscale.com/blog/how-does-database-sharding-work 107 comments
- Dear Postgres - Craig Kerstiens http://www.craigkerstiens.com/2017/10/12/dear-postgres/ 101 comments
- PgBouncer is useful, important, and fraught with peril - JP Camara https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html 83 comments
- PostgreSQL High Availability Options: A Guide https://www.yugabyte.com/postgresql/postgresql-high-availability/ 79 comments
- Implementing "seen by" functionality with Postgres https://supabase.com/blog/2022/07/18/seen-by-in-postgresql 63 comments
- Parsing 18 billion JSON lines with Go | by Roffe | ITNEXT https://medium.com/@roffe/parsing-18-billion-lines-json-with-go-738be6ee5ed2?amp%3Bsk=0a57d3811168ab4d48c37387f69bb92c&source=friends_link 55 comments
- Using PostgreSQL Arrays The Right Way | Heap http://blog.heapanalytics.com/dont-iterate-over-a-postgres-array-with-a-loop/ 55 comments
- GitHub - Vonng/pigsty: PostgreSQL in Great STYle, Battery-Included Free RDS Alternative! https://github.com/Vonng/pigsty 50 comments
- smq/hackernews-top-domains-by-median.md at master · antontarasenko/smq · GitHub https://github.com/antontarasenko/smq/blob/master/reports/hackernews-top-domains-by-median.md 48 comments
- GitHub - citusdata/postgres_vectorization_test: Vectorized executor to speed up PostgreSQL https://github.com/citusdata/postgres_vectorization_test 36 comments
- PR 101 for Engineers. A short guide to the press for… | by Aneel | HackerNoon.com | Medium https://medium.com/@aneel/pr-101-for-engineers-7cd116cc5347#---0-233.ret21dbpx 28 comments
- GitHub - citusdata/pg_shard: ATTENTION: pg_shard is superseded by Citus, its more powerful replacement https://github.com/citusdata/pg_shard 27 comments
- Y Combinator Alum Citus Data Wants To Make Scalable Data Analytics Accessible To Anyone • TechCrunch http://techcrunch.com/2012/06/27/citus-data-launches-new-scalable-analytics-database/ 27 comments
- GitHub - citusdata/pg_cron: Run periodic jobs in PostgreSQL https://github.com/citusdata/pg_cron 24 comments
- GitHub - citusdata/cstore_fdw: Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method. https://github.com/citusdata/cstore_fdw 21 comments