Re: Vacuum and Transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Vacuum and Transactions
Date: 2005-10-04 15:10:18
Message-ID: 8394.1128438618@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor <pg(at)rbt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-10-04 15:23:41 Re: [PERFORM] A Better External Sort?
Previous Message Tom Lane 2005-10-04 15:05:49 Re: Inherited indexes.