Re: [Again] Postgres performance problem - Mailing list pgsql-performance

From db@zigo.dhs.org
Subject Re: [Again] Postgres performance problem
Date
Msg-id 43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org
Whole thread Raw
In response to [Again] Postgres performance problem  (Ruben Rubio <ruben@rentalia.com>)
Responses Re: [Again] Postgres performance problem  (Ruben Rubio <ruben@rentalia.com>)
List pgsql-performance
> Last time I had this problem i solved it stopping website,  restarting
> database, vacuumm it, run again website. But I guess this is going to
> happen again.
>
> I would like to detect and solve the problem. Any ideas to detect it?

Do you have very long transactions? Maybe some client that is connected
all the time that is idle in transaction?

/Dennis


pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
Next
From: "Luke Lonergan"
Date:
Subject: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1