Hi, Kah, [EMAIL PROTECTED] wrote:
> I already vacuum those tables with full option but it still the same. > > What could be the possible causes of this problem? > How can I solve it? > > CPU - Intel Xeon 2.40 GHz > Memory - 1.5G > Postgresql version: 7.2.2 First, you should consider to upgrade your PostgreSQL server to a newer version, at least to 7.2.8 which fixes some critical bugs. But it will be much better to upgrade to current 8.1 version, as I think that your problem is caused by index bloat, and indices are handled much better in 8.1. Try recreating your indices using REINDEX command. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly