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
Tag: Postgresql
Tricks
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:
Documentations
Upsert in SQL
Inserting and updating data with a single query. Source: Upsert in SQL
Link
SQLedge: Replicate Postgres to SQLite on the Edge – https://github.com/zknill/sqledge
Link
“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 you’re not sure how to bridge that gap yourself, how to deploy your first production system with automated failover, then pg_auto_failover is for you.
Source: An introduction to the pg_auto_failover project
I may need it someday