10+ Best Articles on PostgreSQL
The most useful articles on PostgreSQL from around the web—beginners to advanced—curated by thought leaders and our community. We focus on timeless pieces and update the list whenever we discover new, must-read articles or videos—make sure to bookmark and revisit this page.
Top 5 PostgreSQL Articles
At a glance: these are the articles that have been most read, shared, and saved on PostgreSQL by Refind users in 2023 so far.
What is ...?
New to #PostgreSQL? These articles make an excellent introduction.
Introduction to PostgreSQL physical storage
I initially wrote this post for myself, I wanted to understand enough about the underlying physical storage to be able to grasp other concepts which can affect your database. This post is probably…
How to ...?
How to Use PostgreSQL with Node.js
How to set up a pooled connection to PostgreSQL in Node.js and a convenience function for running connections via that pool.
Short Articles
Short on time? Check out these useful short articles on PostgreSQL—all under 10 minutes.
Just Use Postgres for Everything
Startups use too much technology. My advice: Use Postgres for everyting
Speeding up sort performance in Postgres 15
In recent years, PostgreSQL has seen several improvements which make sorting faster. In the PostgreSQL 15 development cycle—which ended in April 2022—Ronan Dunklau, Thomas Munro, Heikki Linnakangas,…
Tricking Postgres into using an insane
At Spacelift, we use PostgreSQL (specifically Aurora Serverless) for most of our primary database needs. This article will show you our optimization story and how PostgreSQL row count estimation can…
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
Postgres Query Plan Visualization
Postgres Explain Visualizer (Pev) is a tool I wrote to make EXPLAIN output easier to grok. It creates a graphical representation of the query plan.
Long Articles
These are some of the most-read long-form articles on PostgreSQL.
SQLite or PostgreSQL? It's Complicated!
Learn how to benchmark SQLite and PostgreSQL databases.
Bye bye Mongo, Hello Postgres
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
Lesser Known PostgreSQL Features
Features you already have but may not know about!
How we optimized PostgreSQL queries 100x
Some of the tricks we used to speed up SELECT-s in PostgreSQL: LEFT JOIN with redundant conditions, VALUES, extended statistics, primary…
The Surprising Impact of Medium-Size Texts on PostgreSQL Performance
Why TOAST is the best thing since sliced bread
Publications
We monitor hundreds of publications, blogs, newsletters, and news sources in PostgreSQL, including:
twilio
Build the future of communications. Do you build? ➡️ @TwilioDevs Need help? ➡️ @TwilioHelp Want a peek inside? ➡️ @WeBuildatTwilio
Towards Data Science
A Medium publication sharing concepts, ideas, and codes. Share your insights and projects with like-minded readers: http://bit.ly/write-for-tds.
The Guardian
The need for independent journalism has never been greater. Become a Guardian supporter: https://support.theguardian.com
What is Refind?
Every day Refind picks 5 links from around the web for every user, tailored to the user’s interests. Picking only a handful of links means focusing on what’s relevant and useful. We favor timeless pieces—links with long shelf-lives, articles that are still relevant one month, one year, or even ten years from now. These lists of the best resources on any topic are the result of years of careful curation.
How does Refind curate?
It’s a mix of human and algorithmic curation, following a number of steps:
- We monitor 10k+ sources and 1k+ thought leaders on hundreds of topics—publications, blogs, news sites, newsletters, Substack, Medium, Twitter, etc.
- In addition, our users save links from around the web using our Save buttons and our extensions.
- Our algorithm processes 100k+ new links every day and uses external signals to find the most relevant ones, focusing on timeless pieces.
- Our community of active users gets 5 links every day, tailored to their interests. They provide feedback via implicit and explicit signals: open, read, listen, share, add to reading list, save to «Made me smarter», «More/less like this», etc.
- Our algorithm uses these internal signals to refine the selection.
- In addition, we have expert curators who manually curate niche topics.
The result: lists of the best and most useful articles on hundreds of topics.
How does Refind detect «timeless» pieces?
We focus on pieces with long shelf-lives—not news. We determine «timelessness» via a number of metrics, for example, the consumption pattern of links over time.
How many sources does Refind monitor?
We monitor 10k+ content sources on hundreds of topics—publications, blogs, news sites, newsletters, Substack, Medium, Twitter, etc.
Which sources does Refind monitor on PostgreSQL?
We monitor hundreds of sources on PostgreSQL, including twilio, Towards Data Science, The Guardian, and many more.
Can I submit a link?
Indirectly, by using Refind and saving links from outside (e.g., via our extensions).
How can I report a problem?
When you’re logged-in, you can flag any link via the «More» (...) menu. You can also report problems via email to hello@refind.com
Who uses Refind?
200k+ smart people start their day with Refind. To learn something new. To get inspired. To move forward. Our apps have a 4.9/5 rating.
Is Refind free?
Yes, it’s free!
How can I sign up?
Head over to our homepage and sign up by email or with your Twitter or Google account.