Learnings

<p>PostgreSQL has a built-in module for removing accents from text </p>

<p>PostgreSQL has a built-in case insensitive text type </p>

<p>PostgreSQL Partitioning in Django: </p>

<p>Index Selectivity: A Key to High Performance SQL </p>

<p>Your Guide to Connection Management in Postgres </p>

<p>In Postgres, "empty updates" have the same cost per row as any other update. Even if the values won't change after the <code>UPDATE</code>, the operation will still have the same performance: </p>

<p>Django needs a <code>GinIndex</code> with <code>OpClass</code> + <code>Upper</code> to support fast queries with the <code>icontains</code> operator: </p>

<p>In Postgres, <code>COUNT(*)</code> vs. <code>COUNT(id)</code> is a non-issue: </p>

<p>How to estimate the size of one column in a Postgres table? </p>

<p>Common DB schema change mistakes: </p>

<p>Thin clones of PostgreSQL to build powerful development, test, and QA envs. Cloning a 1 TiB PostgreSQL database takes ~10 seconds: </p>

<p>How percentile approximation works (and why it's more useful than averages) </p>

<p>Beekeeper Studio - Open Source SQL Editor and Database Manager </p>

<p>Postgres Auditing in 150 lines of SQL: </p>

<p>Using a Replica Router in Django to read your own writes - Scaling Django with Postgres Read Replicas: </p>

<p>How can I cast a DateField() + TimeField() to local time in a Django QuerySet? </p>

<p>PostgreSQL-based Task Queue for Python: </p>

<p>PostgreSQL Anonymizer: </p>

<p>Join strategies and performance in PostgreSQL: </p>

<p>5 ways to host PostgreSQL databases: </p>

<p>Optimizing Pattern Searching Queries in PostgreSQL: </p>

<p>Don't Do This in Postgres: </p>

<p>Finding and killing long running queries on PostgreSQL </p>

<p>Use "identity columns" instead of serial type in Postgres &gt; 10: </p>