http://simonwillison.net/2021-02-03T07:32:33+00:00Simon Willison2021-02-03T07:32:33+00:002021-02-03T07:32:33+00:00https://simonwillison.net/2021/Feb/3/cleaning-your-postgres-database/#atom-tag

<p><strong><a href="https://info.crunchydata.com/blog/cleaning-up-your-postgres-database">Cleaning Up Your Postgres Database</a></strong></p> Craig Kerstiens provides some invaluable tips on running an initial check of the health of a PostgreSQL database, by using queries against the pg_statio_user_indexes table to find the memory cache hit ratio and the pg_stat_user_tables table to see what percentage of queries to your tables are using an index. <p><small></small>Via <a href="https://twitter.com/craigkerstiens/status/1356707553980284928">@craigkerstiens</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/databases">databases</a>, <a href="https://simonwillison.net/tags/performance">performance</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/craig-kerstiens">craig-kerstiens</a></p>

2018-02-01T22:50:00+00:002018-02-01T22:50:00+00:00https://simonwillison.net/2018/Feb/1/citus/#atom-tag

<p><strong><a href="https://www.citusdata.com/blog/2018/02/01/how-citus-database-rebalances-your-data/">How the Citus distributed database rebalances your data</a></strong></p> Citus is a fascinating implementation of database sharding built on top of PostgreSQL primitives. PostgreSQL 10 introduced extremely flexible logical replication—in this post Craig Kerstiens explains how Citus use this new ability to re-balance shards (e.g. when you move from two to four physical PostgreSQL nodes) without downtime. <p>Tags: <a href="https://simonwillison.net/tags/architecture">architecture</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/sharding">sharding</a>, <a href="https://simonwillison.net/tags/zero-downtime">zero-downtime</a>, <a href="https://simonwillison.net/tags/craig-kerstiens">craig-kerstiens</a></p>