Lessons about PostgreSQL (page 5)

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

lessons shared: 83
people sharing: 13
database started in: 2017

dba.stackexchange.com
Is a Postgres long-running query aborted if the connection is lost/broken?
Flávio JuvenalJanuary 21, 2019
stackoverflow.com
Select first row in each GROUP BY group?
Flávio JuvenalJanuary 21, 2019
gist.github.com
List all foreign keys referring to a table and if they're nullable or not with a simple SQL query in Postgres
Hugo BessaJanuary 9, 2019
postgresql.org
PostgreSQL CLUSTER command can speed up large tables that are frequently filtered by a indexed column:
CLUSTER CLUSTER — cluster a table according to an index Synopsis CLUSTER [VERBOSE] table_name [ USING index_name ] CLUSTER [VERBOSE] …
Flávio JuvenalJanuary 4, 2019
theguardian.com
The guardian's story of migrating from MongoDB to PostgreSQL
In April the Guardian switched off the Mongo DB cluster used to store our content after completing a migration to PostgreSQL on Amazon RDS. This post covers why and how
Gustavo CarvalhoDecember 27, 2018
cybertec-postgresql.com
Are triggers really that slow in Postgres?
Flávio JuvenalMay 23, 2018
legitimatesounding.com
Stupid PostgreSQL Tricks: Writable Views (not really recommended, but interesting!):
Flávio JuvenalMay 23, 2018
dba.stackexchange.com
On PostgreSQL, use substring function with regex along with multiple columns on order by to properly mix numeric with alphabetical order:
Flávio JuvenalApril 25, 2018
stackoverflow.com
ORDER BY the IN value list:
Flávio JuvenalApril 3, 2018
help.heroku.com
When looking at your logs you may see sql_error_code = 00000 LOG. No need to worry this is Heroku's way to say "No error here".
Rebeca SaraiMarch 6, 2018
medium.com
9 Django Tips for Working with Databases:
Flávio JuvenalFebruary 15, 2018
blog.heapanalytics.com
Postgres DB-level for-each with LATERAL:
This post walks through a conversion funnel analysis that wouldn’t be possible in PostgreSQL 9.2
Flávio JuvenalJanuary 12, 2018
dba.stackexchange.com
Order of columns in a compound index in PostgreSQL (and query order):
Flávio JuvenalDecember 14, 2017
stackoverflow.com
Will UUID as primary key in PostgreSQL give bad index performance?
Flávio JuvenalDecember 14, 2017
dba.stackexchange.com
Understanding time format of the EXPLAIN command in Postgres
Flávio JuvenalDecember 13, 2017

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 PostgreSQL (page 5)

Is a Postgres long-running query aborted if the connection is lost/broken?

Is a Postgres long-running query aborted if the connection is lost/broken?

Select first row in each GROUP BY group?

Select first row in each GROUP BY group?

List all foreign keys referring to a table and if they're nullable or not with a simple SQL query in Postgres

List all foreign keys referring to a table and if they're nullable or not with a simple SQL query in Postgres

PostgreSQL CLUSTER command can speed up large tables that are frequently filtered by a indexed column:

PostgreSQL CLUSTER command can speed up large tables that are frequently filtered by a indexed column:

The guardian's story of migrating from MongoDB to PostgreSQL

The guardian's story of migrating from MongoDB to PostgreSQL

Are triggers really that slow in Postgres?

Are triggers really that slow in Postgres?

Stupid PostgreSQL Tricks: Writable Views (not really recommended, but interesting!):

Stupid PostgreSQL Tricks: Writable Views (not really recommended, but interesting!):

On PostgreSQL, use `substring` function with regex along with multiple columns on `order by` to properly mix numeric with alphabetical order:

On PostgreSQL, use `substring` function with regex along with multiple columns on `order by` to properly mix numeric with alphabetical order:

ORDER BY the IN value list:

ORDER BY the IN value list:

When looking at your logs you may see `sql_error_code = 00000 LOG`. No need to worry this is Heroku's way to say "No error here".

When looking at your logs you may see `sql_error_code = 00000 LOG`. No need to worry this is Heroku's way to say "No error here".

9 Django Tips for Working with Databases:

9 Django Tips for Working with Databases:

Postgres DB-level for-each with LATERAL:

Postgres DB-level for-each with LATERAL:

Order of columns in a compound index in PostgreSQL (and query order):

Order of columns in a compound index in PostgreSQL (and query order):

Will UUID as primary key in PostgreSQL give bad index performance?

Will UUID as primary key in PostgreSQL give bad index performance?

Understanding time format of the EXPLAIN command in Postgres

Understanding time format of the EXPLAIN command in Postgres

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

Lessons about PostgreSQL (page 5)

Is a Postgres long-running query aborted if the connection is lost/broken?

Select first row in each GROUP BY group?

List all foreign keys referring to a table and if they're nullable or not with a simple SQL query in Postgres

PostgreSQL CLUSTER command can speed up large tables that are frequently filtered by a indexed column:

The guardian's story of migrating from MongoDB to PostgreSQL

Are triggers really that slow in Postgres?

Stupid PostgreSQL Tricks: Writable Views (not really recommended, but interesting!):

On PostgreSQL, use substring function with regex along with multiple columns on order by to properly mix numeric with alphabetical order:

ORDER BY the IN value list:

When looking at your logs you may see sql_error_code = 00000 LOG. No need to worry this is Heroku's way to say "No error here".

9 Django Tips for Working with Databases:

Postgres DB-level for-each with LATERAL:

Order of columns in a compound index in PostgreSQL (and query order):

Will UUID as primary key in PostgreSQL give bad index performance?

Understanding time format of the EXPLAIN command in Postgres

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

On PostgreSQL, use `substring` function with regex along with multiple columns on `order by` to properly mix numeric with alphabetical order:

When looking at your logs you may see `sql_error_code = 00000 LOG`. No need to worry this is Heroku's way to say "No error here".

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