4 ms·
Have the shipped configs improved to the point that you get a production database out of the gate? I've been using (and loving) psql for years, but I've never o
by tdavis 17y ago
Have the shipped configs improved to the point that you get a production database out of the gate? I've been using (and loving) psql for years, but I've never once trusted the default postgresql.conf.
- tsuraan 17y agoUnder Gentoo, at least, the default postgresql.conf is still garbage. limit of 100 connections, hardly any shared memory, really nothing about it is good. I don't think shipping a good config file is possible though; we need a good config file generator, that looks at kernel configuration and hardware configuration and makes a good config based off that. It doesn't look like such a thing exists though.
- bayareaguy 17y agoDoesn't the Enterprise DB distribution of PostgreSQL include a tuning wizard? http://www.enterprisedb.com/products/postgres_plus/overview.do http://www.enterprisedb.com/products/postgres_plus/overview....
- rbanffy 17y agoLast time I checked on Debian, no. But it was more or less painless - just edit a couple settings on the config files and you are good to go. IIRC, I had to adjust memory footprint (telling PostgreSQL to feel at home and use all it wanted to use) and tell it to trust the disk subsystem and the UPS (turning synchronous writes off). From that point on, it withstood a huge beating.