Speeding up index creation in PostgreSQL
Paolo Redaelli
In this blog we are talking about indexes. Speeding up index creation in PostgreSQL is one of the main topic. Source: Speeding up index creation in PostgreSQL
Postgresql
Versioning data in Postgres? Testing a git like approach – Specfy
Versioning data in Postgres? Testing a git like approach – Specfy is fashinating but I think that most of the time these two proposed alternatives fit most of the needs:
Upsert in SQL
Inserting and updating data with a single query. Source: Upsert in SQL
SQLedge
SQLedge: Replicate Postgres to SQLite on the Edge – https://github.com/zknill/sqledge
An introduction to the pg_auto_failover project
“Postgres is awesome, makes developping my application so much easier, it solves so many problems for me!” and the next step “so, how do I run Postgres in Production?”. If…