Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin - Mailing list pgsql-performance

From Tom Lane
Subject Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Date
Msg-id 17770.1108737145@sss.pgh.pa.us
Whole thread Raw
In response to Degradation of postgres 7.4.5 on FreeBSD/CygWin  ("Rodrigo Moreno" <rodrigo.miguel@terra.com.br>)
Responses Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin  ("Rodrigo Moreno" <rodrigo.miguel@terra.com.br>)
List pgsql-performance
"Rodrigo Moreno" <rodrigo.miguel@terra.com.br> writes:
> After 2 months, postgres start get down the performance, and simple queries
> that should run in 100ms now tooks about 15 secs.

> Another behaviour, the data is growing to much, with no reason, just like
> the comparision.

Are you vacuuming on a regular basis?  Do you have the FSM settings high
enough to cover the database?

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Effects of IDLE processes
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin