PostgreSQL 8.1 + ZABBIX 1.4.2 + FreeBSD 7.1 Optimization [Archive]

View Full Version : PostgreSQL 8.1 + ZABBIX 1.4.2 + FreeBSD 7.1 Optimization

d_pilot

28-03-2009, 05:23

Hi.
My database is very large. Size is about 150 GB. System works 1 year uptime.
Because of that WEB site works very slowly. Above 10 minutes per page.
Everything installed by default.
How can I optimized my system?

outi

28-03-2009, 13:32

Since PostgreSQL 8.1 does not use auto-vacuum, you do regular vacuums of your db, right? Running vacuum may take some time on such huge databases, but it's worth a try.

Additionally you may enable logging of slow queries and use pgfouine to get a feeling on what is really slow and where adding indices may help to increase performance.