Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of the listen command - Mailing list pgsql-general

From Flemming Frandsen
Subject Re: Performance of the listen command
Date
Msg-id 44CB74BE.6020407@partyticket.net
Whole thread Raw
In response to Re: Performance of the listen command  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Flemming Frandsen
Date:
Subject: Re: Performance of the listen command
Next
From: Tom Lane
Date:
Subject: Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation