Horton
Menu

Re: AutoVacuum starvation from sinval messages

Hannu Krosing <hannu@2ndquadrant.com>

View thread
From: Hannu Krosing <hannu@2ndQuadrant.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Jeff Janes <jeff.janes@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-11-08T22:50:44Z
Lists: pgsql-hackers 
On 11/08/2012 11:40 PM, Simon Riggs wrote:
> 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?
>
Could heavy use of temporary tables cause this ?

Hannu