Re: [Again] Postgres performance problem

From: db(at)zigo(dot)dhs(dot)org
To: "Ruben Rubio" <ruben(at)rentalia(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [Again] Postgres performance problem
Date: 2007-09-11 07:31:23
Message-ID: 43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2007-09-11 07:33:47 Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
Previous Message Gregory Stark 2007-09-11 07:28:59 Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1