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.
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.
Nine ways to shoot yourself in the foot with PostgreSQL
23rd April 2023 Previously on Extreme Learning, I discussed all the ways I've broken production using healthchecks. In this post I'll do the same for PostgreSQL. The common thread linking most of…
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…
Just Use Postgres for Everything
Startups use too much technology. My advice: Use Postgres for everyting
Postgres: The Graph Database You Didn't Know You Had
PostgreSQL (Postgres), is a powerful relational database that can store a wide range of data types...
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.
Lesser Known PostgreSQL Features
Features you already have but may not know about!
Understanding database Indexes in PostgreSQL
Understand SQL indexes, organize your knowledge, and memorize good practices regarding performance optimization in PostgreSQL.
The Surprising Impact of Medium-Size Texts on PostgreSQL Performance
Why TOAST is the best thing since sliced bread
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
What is Refind?
Every day Refind picks the most relevant links from around the web for you. 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 the most relevant links every day, tailored to their interests. They provide feedback via implicit and explicit signals: open, read, listen, share, mark as read, read later, «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.
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?
300k+ 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.