Re: [PERFORM] Postgres running Very slowly

2007-10-09 Thread Bill Moran
In response to Radhika S [EMAIL PROTECTED]: Hi -, I have a very peculiar situation. I am running a postgres 7.4.6 database. It is running slow... . 7.4.6 is very old. You're lucky it hasn't corrupted your data. At least upgrade to the latest 7.4.18 (yes, that's 12 patches ahead of

[PERFORM] Postgres running Very slowly

2007-10-09 Thread Radhika S
Hi -, I have a very peculiar situation. I am running a postgres 7.4.6 database. It is running slow... . I vacuum --analyze daily. I just did again. I did a vacuum full last night. But to no avail. CPU usage and memory are normal, but the system is crawling. Here is the info from vacuum.