Re: AW: AW: AW: AW: Vacuum only with 20% old tuples - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: AW: AW: AW: Vacuum only with 20% old tuples
Date
Msg-id 7982.964706622@sss.pgh.pa.us
Whole thread Raw
In response to AW: AW: AW: AW: Vacuum only with 20% old tuples  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> But yes the rename log entries (only those) would need to be 
> written immediately. Is this a performance issue? I guess not.

Two fsyncs per rename is probably not a performance killer, but you'd
have to also fsync log entries for file creates and deletes, which
might be a bigger deal.
        regards, tom lane


pgsql-hackers by date:

Previous
From: frank
Date:
Subject: Re: Is Pg 7.0.x's Locking Mechanism BROKEN?
Next
From: Bruce Momjian
Date:
Subject: Re: Loading binary data into the database