PDA

View Full Version : Speeding Up PostgreSQL on Ubuntu



SuperMike
January 8th, 2007, 08:33 PM
I hear there are changes I can make in my postgresql.conf to speed up PostgreSQL from its defaults. The defaults are set to work on a low-end system, not a high-end system. Can you describe what optimizations are highly recommended on Ubuntu Server with a powerful server?

xav42
January 9th, 2007, 03:22 PM
Hi,

Here is what you're looking for :
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

Regards.