Show HN: Postgresqlco.nf: PostgreSQL Configuration for Humans

Re:Show HN: Postgresqlco.nf: PostgreSQL Configuration for Hu... by vbezhenar on Friday January 24, 2020 @01:28PM (#22141052)

I never made any changes to Postgres for development and it was blazing fast. I made few simple changes for production to let it use more memory (just few lines that you'll find in any guide) and that was about it. I guess, there are plenty of handles for very pro users when they need to squeeze last few percents of performance, but generally it just works fast.

[ Parent | on HN ]

Re:Show HN: Postgresqlco.nf: PostgreSQL Configuration for Hu... by topspin on Friday January 24, 2020 @05:52PM (#22143150)

This site is actually misleading in my opinion; someone with no prior exposure might think postgresql users are obligated to spend their time in endless configuration push ups. That is definitely not the case. As the parent points out, developers rarely have to change more than a few things. Production means real loads and real loads drive administrators to configure and tune, but that's as true for MySQL/MariaDB as it is for Postgresql.

Over here[1] you can read about the 1163 snake cased MariaDB variables if you want... 231 of them are specific to innodb alone.

[1] https://mariadb.com/kb/en/server-system-variables/

[ Parent | on HN ]

Re:Show HN: Postgresqlco.nf: PostgreSQL Configuration for Hu... by RobertRoberts on Friday January 24, 2020 @01:36PM (#22141110)

Thanks, that is what I was hoping for.

[ Parent | on HN ]