pgstat delay in autovacuum

Started by Alvaro Herreraover 17 years ago3 messageshackers
Jump to latest
#1Alvaro Herrera
alvherre@2ndquadrant.com

Hi,

With the new request-based pgstat reading mechanism, it is easy to fix
an autovacuum "bug". Basically for an autovac worker the delay is
reduced, so that the data is very fresh. Patch attached.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Attachments:

autovac-pgstat-delay.patchtext/x-diff; charset=us-asciiDownload+13-13
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alvaro Herrera (#1)
Re: pgstat delay in autovacuum

Alvaro Herrera <alvherre@commandprompt.com> writes:

With the new request-based pgstat reading mechanism, it is easy to fix
an autovacuum "bug". Basically for an autovac worker the delay is
reduced, so that the data is very fresh. Patch attached.

It would be nice if the patch didn't render the adjacent comment a lie.

regards, tom lane

#3Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Tom Lane (#2)
Re: pgstat delay in autovacuum

Tom Lane wrote:

Alvaro Herrera <alvherre@commandprompt.com> writes:

With the new request-based pgstat reading mechanism, it is easy to fix
an autovacuum "bug". Basically for an autovac worker the delay is
reduced, so that the data is very fresh. Patch attached.

It would be nice if the patch didn't render the adjacent comment a lie.

Yep, thanks -- fixed and committed.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.