Re: Slow in morning hours

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Slow in morning hours
Дата
Msg-id 20040220121945.GB15383@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Slow in morning hours  (<vathakar@banas.guj.nic.in>)
Список pgsql-performance
On Fri, Feb 20, 2004 at 02:46:15PM +0530, vathakar@banas.guj.nic.in wrote:
>
> After continuous usage of one hour, It gradually starts responding
> faster ! This has become every day routine !
>
> do u have any idea related to this !!!! Is there any other reason that I
> need to check up?

What's running on the machine during those hours?  Maybe VACUUM is
sucking up all your bandwidth.  Or your backups.  Or some other
cron job.

Note that 7.2 is pretty old.  There are several performance
improvements in subsequent versions.

A

--
Andrew Sullivan

В списке pgsql-performance по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Slow in morning hours
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Slow in morning hours