Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rodrigo Moreno" <rodrigo(dot)miguel(at)terra(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Date: 2005-02-18 14:32:25
Message-ID: 17770.1108737145@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Rodrigo Moreno" <rodrigo(dot)miguel(at)terra(dot)com(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-02-18 14:40:21 Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Previous Message Tom Lane 2005-02-18 14:16:40 Re: Effects of IDLE processes