Re: Vacuum and Transactions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuum and Transactions
Date
Msg-id 8394.1128438618@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum and Transactions  (Rod Taylor <pg@rbt.ca>)
Responses Re: Vacuum and Transactions
List pgsql-hackers
Rod Taylor <pg@rbt.ca> writes:
> The catch is that there are some other very active structures (like
> pg_listener for Slony) which after a couple of hours without vacuuming
> will quickly have the DB at an unreasonably high load (low tens) which
> seems to all but halt the vacuum on the large structure.

Yeah.  We desperately need to reimplement listen/notify :-( ... that
code was never designed to handle high event rates.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [PERFORM] A Better External Sort?
Next
From: Tom Lane
Date:
Subject: Re: Inherited indexes.