On Fri, 2007-10-12 at 10:19 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > I think the best way to handle this is to have two limits. > > First limit attempts to autovacuum, but can be cancelled. > > When we hit second limit, sometime later, then autovacuum cannot be > > cancelled. > > This seems like uselessly complex overdesign.
OK > In short: put in the automatic lock cancel for regular vacuums, disable > it for antiwraparound vacuums, but don't disable manual cancels; and > definitely don't invent a complicated new set of behaviors around that. That seemed more complex when I thought about that, but if we just use SIGUSR2 for automatic cancels then this would be very simple. Or did you have another design? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate