Lessons about DB (page 3)

The links, tools and tips our engineers and designers share with each other, one “today I learned” at a time.

lessons shared: 68
people sharing: 8
database started in: 2017

stackoverflow.com
Log all queries of Postgres on docker-compose:
Flavio JuvenalMarch 8, 2021
percona.com
Handling NULL values in Postgresql
Writing queries involving NULL can be tricky, particularly in PostgreSQL. Learn about the multiple meanings of NULL in PostgreSQL to avoid errors.
João PedroFebruary 26, 2021
seddonym.me
The trouble with transaction atomic:
Rebeca SaraiDecember 4, 2020
brianlikespostgres.com
The cost of a join and some benchmarks
Rebeca SaraiNovember 17, 2020
Link offline
build.affinity.co · offline
How we used Postgres extended statistics to achieve a 3000x speedup:
Flavio JuvenalAugust 27, 2020
klotzandrew.com
Quickly debugging Postgres problems:
Flavio JuvenalAugust 27, 2020
thoughtbot.com
Reading a Postgres EXPLAIN ANALYZE Query Plan:
Take a guided tour through a query plan for a “simple” SQL query.
Flavio JuvenalAugust 27, 2020
adamj.eu
How to Modernize a Django Index Definition with Zero Downtime:
If you’ve read the Django documentation for Model.Meta.index_together recently, you may have noticed this note:
Flavio JuvenalAugust 5, 2020
dba.stackexchange.com
Is it worth it to run VACUUM on a table that only receives INSERTs?
Flavio JuvenalJuly 23, 2020
medium.com
Eight tips to relieve those Postgres headaches:
Flavio JuvenalJune 25, 2020
github.com
Django application providing queryset sealing capability to force appropriate usage of only()/defer() and select_related()/ prefetch_related()
Flavio JuvenalMay 7, 2020
stackoverflow.com
When using psycopg2's ThreadedConnectionPool, an additional sempahore is needed to avoid "connection pool exhausted" errors:
Flávio JuvenalApril 13, 2020
medium.com
Lessons learned scaling PostgreSQL database to 1.2bn records/month:
Flávio JuvenalFebruary 3, 2020
speakerdeck.com
PostgreSQL Configuration for Humans:
Video: https://www.youtube.com/watch?v=IFIXpm73qtk PostgreSQL is the world’s most advanced open source database. Indeed! With around 270 configuratio…
Flávio JuvenalOctober 23, 2019
pgdash.io
Getting The Most Out Of Your PostgreSQL Indexes:
Flávio JuvenalMay 27, 2019

More lessons

Book a call

Found it useful?
Let’s put it to work.

Tell us about your product and the problem in front of you. We’ll bring what we’ve learned on real projects.

Tell us about your product, and we’ll bring what we’ve learned.

Still prefer the good old email? Contact us

Book a call

Lessons about DB (page 3)

Log all queries of Postgres on docker-compose:

Log all queries of Postgres on docker-compose:

Handling NULL values in Postgresql

Handling NULL values in Postgresql

The trouble with transaction atomic:

The trouble with transaction atomic:

The cost of a join and some benchmarks

The cost of a join and some benchmarks

How we used Postgres extended statistics to achieve a 3000x speedup:

How we used Postgres extended statistics to achieve a 3000x speedup:

Quickly debugging Postgres problems:

Quickly debugging Postgres problems:

Reading a Postgres EXPLAIN ANALYZE Query Plan:

Reading a Postgres EXPLAIN ANALYZE Query Plan:

How to Modernize a Django Index Definition with Zero Downtime:

How to Modernize a Django Index Definition with Zero Downtime:

Is it worth it to run VACUUM on a table that only receives INSERTs?

Is it worth it to run VACUUM on a table that only receives INSERTs?

Eight tips to relieve those Postgres headaches:

Eight tips to relieve those Postgres headaches:

Django application providing queryset sealing capability to force appropriate usage of `only()`/`defer()` and `select_related()`/ `prefetch_related()`

Django application providing queryset sealing capability to force appropriate usage of `only()`/`defer()` and `select_related()`/ `prefetch_related()`

When using psycopg2's ThreadedConnectionPool, an additional sempahore is needed to avoid "connection pool exhausted" errors:

When using psycopg2's ThreadedConnectionPool, an additional sempahore is needed to avoid "connection pool exhausted" errors:

Lessons learned scaling PostgreSQL database to 1.2bn records/month:

Lessons learned scaling PostgreSQL database to 1.2bn records/month:

PostgreSQL Configuration for Humans:

PostgreSQL Configuration for Humans:

Getting The Most Out Of Your PostgreSQL Indexes:

Getting The Most Out Of Your PostgreSQL Indexes:

Found it useful?
Let’s put it to work.

Lessons about DB (page 3)

Log all queries of Postgres on docker-compose:

Handling NULL values in Postgresql

The trouble with transaction atomic:

The cost of a join and some benchmarks

How we used Postgres extended statistics to achieve a 3000x speedup:

Quickly debugging Postgres problems:

Reading a Postgres EXPLAIN ANALYZE Query Plan:

How to Modernize a Django Index Definition with Zero Downtime:

Is it worth it to run VACUUM on a table that only receives INSERTs?

Eight tips to relieve those Postgres headaches:

Django application providing queryset sealing capability to force appropriate usage of only()/defer() and select_related()/ prefetch_related()

When using psycopg2's ThreadedConnectionPool, an additional sempahore is needed to avoid "connection pool exhausted" errors:

Lessons learned scaling PostgreSQL database to 1.2bn records/month:

PostgreSQL Configuration for Humans:

Getting The Most Out Of Your PostgreSQL Indexes:

Found it useful? Let’s put it to work.

Django application providing queryset sealing capability to force appropriate usage of `only()`/`defer()` and `select_related()`/ `prefetch_related()`

Found it useful?
Let’s put it to work.