Re: Performance of the listen command

Поиск
Список
Период
Сортировка
От Flemming Frandsen
Тема Re: Performance of the listen command
Дата
Msg-id 44CB74BE.6020407@partyticket.net
обсуждение исходный текст
Ответ на Re: Performance of the listen command  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
Дерево обсуждения 
Michael Fuhr wrote:
> What's the output of "VACUUM VERBOSE pg_listener"?  If you vacuum
> pg_listener do the listens run faster?

Actually now that You mentioned vacuming, I tried doing a VACUUM and
after it was done request time was down to around a tenth of what it was
before.

iow. requests that took 500ms before are now down to around 25ms.

I will now hang my head in shame, please forgive me.

--
  Regards Flemming Frandsen - http://dion.swamp.dk - YAPH

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

Предыдущее
От: Flemming Frandsen
Дата:
Сообщение: Re: Performance of the listen command
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation