Hacker News
- Citus 11 for Postgres goes fully open source, with query from any node https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/ 3 comments
- 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
- Distributed count distinct vs. HyperLogLog in Postgres https://www.citusdata.com/blog/2017/12/22/distributed-count-vs-hyperloglog/ 11 comments
- Citus 6.1 Released – Horizontally scale your Postgres database https://www.citusdata.com/blog/2017/02/16/citus-61-released/ 38 comments
- Postgres Parallel Indexing in Citus https://www.citusdata.com/blog/2017/01/17/parallel-indexing-with-citus/ 3 comments
- Scaling out relational data models, and SQL, through co-location https://www.citusdata.com/blog/2016/12/22/scaling_out_sql_with-colocation/ 16 comments
- Real-time event aggregation at scale using Postgres with Citus https://www.citusdata.com/blog/2016/11/29/event-aggregation-at-scale-with-postgresql/ 11 comments
- Postgres Count Performance https://www.citusdata.com/blog/2016/10/12/count-performance?source=pg_weekly 31 comments
- Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB https://www.citusdata.com/blog/2016/07/14/choosing-nosql-hstore-json-jsonb/ 43 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
Lobsters
- 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