jiniusatwork-postgresql@xxxxxxxxx wrote:
Thanks for the reply. Unfortunately, the project I'm working is trying to provide "database-as-a-service" functionality, so I can't really tune the DB since the application/load will vary by customer (and the whole idea was to abstract all the low-level tuning parameters from the customer because we aren't expecting "power" users).
Tune for your hardware, ram, disc array and config. Not for specific workload. There is no way the initdb defaults can be sane for any production setup.
-- Best regards, Hannes Dorbath ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
