Bookmarks with tag "postgres", page 1 of 4
Columns represent our data, and their order of definition directly impacts storage. What if there were a way to optimize this for real, tangible benefit?
Visualizing and understanding your PostgreSQL execution plans made easy.
Get to know and learn how to use some less-known features of Version 12 of PostgreSQL. You'll surely discover something new for yourself.
The Oversized-Attribute Storage Technique
Samples of b-tree, GIN, and GIST indexes for Postgres beginners.
Reorganize tables in PostgreSQL databases with minimal locks
This article gives a brief introduction to EXPLAIN ANALYZE, explains what to look for and shows some helpful tools to visualize the output.
Check the connection status of a PostgreSQL server
YouTube-like Short IDs as Postgres Primary Keys.
At work I was tasked to migrate our time-series analytics data from CSV file dumps that we’ve been feeding into Power BI to a dedicated database. Our Rails app’s primary database is currently MariaDB, but we wanted to have our analytics data in a separate database either way, so this was a good opportunity to use Postgres which we’re most comfortable with anyway.
Learn about smaller indexes with B-Tree Deduplication, Extended Statistics Improvements, Parallel VACUUM, improved WAL Usage Stats in Postgres 13, and more.
TL;DR: When you are making a new application that requires persistent storage of data, like is the case for most web applications, your default choice should be Postgres