PostgreSQL 8.1 + ZABBIX 1.4.2 + FreeBSD 7.1 Optimization

[d_pilot]

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]

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.