Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does VACUUM FULL bother locking pages? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Why does VACUUM FULL bother locking pages?
Date
Msg-id KGEFLMPJFBNNLNOOOPLGCEFHCJAA.simon@2ndquadrant.com
Whole thread Raw
In response to Why does VACUUM FULL bother locking pages?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Why does VACUUM FULL bother locking pages?
List pgsql-hackers
Tree view 
> Alvaro Herrera wrote
> The only caller of both is
> repair_frag, whose only caller in turn is full_vacuum_rel.

...bgwriter still needs to access blocks. The WAL system relies on the
locking behaviour for recoverability, see comments in LockBuffer() and
SyncOneBuffer().

...I do think there's lots still to optimise in VACUUM FULL though...

Best Regards, Simon Riggs

pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Why does VACUUM FULL bother locking pages?
Next
From: "Simon Riggs"
Date:
Subject: Re: statement_timeout logging