Hacker News new | past | comments | ask | show | jobs | submit login
PostgreSQL Operations Cheat Sheet: featuring security, scaling, structure, etc. (postgresql.org)
125 points by olestr on Jan 18, 2024 | hide | past | favorite | 6 comments



Still reading it But I think this is a pretty good idea. Too often the devs don't really want to take a stance, which on the one hand is understandable, you don't want to be telling people how to run their databases. However on the other hand this can be very hard for a beginner. It can be invaluable to be able to start with a known good config, a checklist of "best" practices, and some cautionary war stories on edge cases to avoid.


For nice interactive search of configuration options I always go to https://postgresqlco.nf/doc/en/param/


Hmmm. On the face of it, this looks nice, and seems like a decent starting point, but a couple concerns come to mind.

First, reading the history indicates that the page as it stands it new and the work of a single individual. That's not necessarily bad, but it does mean that you have to interpret this assuming it could be too narrow or limited to the qualifications of that single author. Surely time will correct this, but any advice need to be seen through that lens.

Second, my brief look didn't see version differences discussed. For example, PostgreSQL had historically had issues with large connection counts (and still does). But the degree had changed over time as work had been done (and continues to be done) to make this problem less a problem. One size fits all advice simply doesn't give you what you might need for your version. The talk page rightfully calls this out


This is quite the amazing resource, I have bookmarked it.

Unfortunately, there is a formatting problem about 5% into that renders the rest of the page somewhat garbled. And it is a closed wiki, so I can't just create an account and fix it.


Is there something similar for SQL Server?





Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: