Re: [Again] Postgres performance problem

Поиск
Список
Период
Сортировка
От db@zigo.dhs.org
Тема Re: [Again] Postgres performance problem
Дата
Msg-id 43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org
обсуждение исходный текст
Ответ на [Again] Postgres performance problem  (Ruben Rubio <ruben@rentalia.com>)
Ответы Re: [Again] Postgres performance problem  (Ruben Rubio <ruben@rentalia.com>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1