How to write high-performance SQL for your Postgres database

pgnanalyze helps users deliver consistent PostgreSQL performance and availability at any scale. Get started with a free trial or explore their docs. You can also find them on YouTube, where Lukas posts a weekly show called 5mins of Postgres.

Lukas was a founding engineer of Citus Data. Citus is an open-source extension to PostgreSQL that was eventually acquired by Microsoft. Find them on GitHub.

If you’re new to the topic, SQL (Structured Query Language) is a language for querying databases, introduced in the 1970s.

WD_BLACK 2TB SN7100 NVMe Internal Gaming SSD Solid State Drive - Gen4 PCIe, M.2 2280, Up to 7,250 MB/s - WDS200T4X0E [New Version]

(4751195)

7% Off $139.99 $128.99 (as of August 11, 2025 13:42 GMT +03:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

HIGH-OCTANE GAMING. Experience speeds up to 7,250MB/s(2) read and 6,900MB/s2 write (1-2TB(1) models), with up to 35% faster performance than previous generation(4). PURPOSE-BUILT. Designed for serious on-the-go gamers, with a PCIe Gen4 interface and ... read more

Find Lukas on LinkedIn, Twitter, or GitHub.

TRANSCRIPT

Source: https://stackoverflow.blog/2023/09/28/how-to-write-high-performance-sql-for-your-postgres-database/

You might also like this video