Postgres Pro
Downloads
Home   >   mailing lists

Re: performance problem with version 7.0.3 - Mailing list pgsql-admin

From Tom Lane
Subject Re: performance problem with version 7.0.3
Date
Msg-id 20867.1012236718@sss.pgh.pa.us
Whole thread Raw
In response to performance problem with version 7.0.3  (juerg.rietmann@pup.ch)
List pgsql-admin
Tree view 
juerg.rietmann@pup.ch writes:
> Please help me in analyzing this output. After vacuum/analyze, the
> performance is ok for another month.

So, vacuum on a regular basis.  Most people do it at least once a day.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Marc Mitchell"
Date:
Subject: PRIMARY KEY Indexes.
Next
From: Stephan Szabo
Date:
Subject: Re: PRIMARY KEY Indexes.