Re: AutoVacuum starvation from sinval messages - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AutoVacuum starvation from sinval messages
Date
Msg-id 21893.1352417026@sss.pgh.pa.us
Whole thread Raw
In response to Re: AutoVacuum starvation from sinval messages  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: AutoVacuum starvation from sinval messages  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On 8 November 2012 20:36, Jeff Janes <jeff.janes@gmail.com> wrote:
>> It does not seem outrageous to me that there would be real-world
>> conditions in which invalidations would be sent more than once a
>> minute over prolonged periods, so this total starvation seems like a
>> bug.

> Yes, its a bug, but do you really believe the above? In what cases?

It doesn't take a whole lot of DDL to provoke an sinval overrun, if
the recipient process is just sitting idle and not servicing the
messages.  I think Jeff's concern is entirely valid.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: TRUNCATE SERIALIZABLE and frozen COPY
Next
From: Jeff Janes
Date:
Subject: Re: Further pg_upgrade analysis for many tables