Top all-time · #3636
pgDash Blog
Company blog · pgdash.io/blogdataprogramming
pgDash Blog is the company blog at pgdash.io, writing about data and programming. Since 2018, 20 different Hacker News readers have linked it 71 times, most often “Sharding Your Data with PostgreSQL 11”. It is still writing: the last post was on 2026-05-11, and you can follow it by feed.
pgDash is a comprehensive monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
Most-linked posts?
- Sharding Your Data with PostgreSQL 115 people · 5 mentions · first linked 2018-08-09
- PostgreSQL 11 Partitioning Improvements2 people · 2 mentions · first linked 2018-05-21
- PostgreSQL Features You May Not Have Tried but Should2 people · 2 mentions · first linked 2018-06-19
What Hacker News says?
Does anybody know where I can find an example of hash partitioning? I see it mentioned here in the docs but am having trouble finding an example: https://www.postgresql.org/docs/11/static/ddl-partitioning.h... edit: Found an example here: https://pgdash.io/blog/partition-postgres-11.html Followup question: Is there a way to re-partition? Say, if your data grows and you want to split the data up further?
Comment linking /blog/partition-postgres-11.html
on “PostgreSQL 11 Released”Submitted New In Postgres 12: Generated Columns as a story · 516 points
HN discussionI wish them well but fear this won't work out for them. This sounds like a smart move until you realize that they are just one of many players in a crowded market and that this actually decreases their value proposition for end users and external contributors. Having less of both is bad news for an OSS project, no matter how you spin it. The way I see it this type of company has a short term value that derives from…
Comment linking /blog/postgres-11-sharding.html
on “Relicensing CockroachDB”Submitted PostgreSQL Features to Try as a story · 378 points
HN discussionA bunch of Postgres pain points: https://pgdash.io/blog/postgresql-six-not-so-easy-pieces.htm...
Comment linking /blog/postgresql-six-not-so-easy-pieces.html
on “Index bloat reduced in PostgreSQL v14”Submitted PostgreSQL 11 Partitioning Improvements as a story · 361 points
HN discussionPostgreSQL directly supports table sharding. https://pgdash.io/blog/postgres-11-sharding.html Schema evolution is supported by pretty much every ORM you'd care to use; it's not the job of the SQL database to handle the migration. I'm using Prisma and you literally change the software spec for the schema and say "migrate", and it creates the migration SQL and applies it to the Postgres DB programmatically. That gets…
Comment linking /blog/postgres-11-sharding.html
on “Never use MongoDB (2013)”Submitted Vertically Scaling PostgreSQL as a story · 330 points
HN discussionI like this approach and have successfully used both table partitioning [1] and (if necessary) foreign data wrappers [2] to keep my main database small and fast. There is a pretty old blog post that clued me into it [3]. It works really nicely, allowing for such things as old data stored on spinning disks and newer data on NVMe drives. You can query the main table directly with query parameters that limit which part…
Comment linking /blog/postgres-11-sharding.html
on “Cleaning Up Your Postgres Database”- _1 · 2018-06-20
Submitted PostgreSQL Features You May Not Have Tried but Should as a story · 255 points
HN discussion This is a great initiative. Benchmarking managed services is notoriously tricky due to varying configurations and 'black-box' optimizations. For anyone looking to run these benchmarks on their own or wanting to dive deeper into the why behind the numbers, pgmetrics ( https://pgmetrics.io ) is a fantastic open-source tool. It collects a massive amount of internal PG stats into a structured JSON format, making it easy…
Comment linking /
on “PostgresBench: A Reproducible Benchmark for Postgres Services”Submitted RAG with PostgreSQL as a story · 46 points
HN discussionGreat write-up—the distinction between healthy OS caching and actual memory pressure is often misunderstood. To get a granular view of where your memory is actually going (shared buffers, cache hits, etc.) without the overhead of heavy agents, pgmetrics ( https://pgmetrics.io ) is very effective. If you need to track these metrics over time to catch when 'good' caching turns into 'bad' pressure, pgDash ( https://pgd…
Comment linking /
on “High memory usage in Postgres is good”Submitted Sharding Your Data with PostgreSQL 11 as a story · 26 points
HN discussionYou might like this static full year planner version: https://pgdash.io/2026
Comment linking /2026
on “I found the perfect yearly calendar (for me)”Submitted pg_ctl tips and tricks as a story · 22 points
HN discussionSubmitted Getting the Most Out of Your PostgreSQL Indexes as a story · 19 points
HN discussionSubmitted Configuring PostgreSQL for Observability as a story · 5 points
HN discussionSubmitted Getting the Most Out of Your PostgreSQL Indexes as a story · 5 points
HN discussionSubmitted PostgreSQL 11: What's New as a story · 5 points
HN discussionSubmitted Psql (PostgreSQL Shell) Tips and Tricks as a story · 5 points
HN discussionSubmitted Postgres Tips and Tricks as a story · 4 points
HN discussionSubmitted Postgres Tips and Tricks as a story · 4 points
HN discussionSubmitted Understanding PostgreSQL Query Performance as a story · 4 points
HN discussionSubmitted Getting the Most Out of Your PostgreSQL Indexes as a story · 4 points
HN discussionSubmitted PostgreSQL: The Versatile INSERT as a story · 4 points
HN discussionSubmitted 7 Things to Watch Out for in Your PostgreSQL Deployment as a story · 4 points
HN discussionSubmitted All About Tablespaces in PostgreSQL as a story · 4 points
HN discussionSubmitted Physical Replication Mechanisms in PostgreSQL as a story · 3 points
HN discussionSubmitted PostgreSQL Incremental Backup and Point-in-Time Recovery as a story · 3 points
HN discussion
