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

From Zeugswetter Andreas SB
Subject AW: AW: AW: AW: AW: Vacuum only with 20% old tuples
Date
Msg-id 11C1E6749A55D411A9670001FA68796336803A@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > 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.

I am not sure, but I don't think those are necessary,
only if you want to guarantee no leftover files on backend abort.
I agree that create/delete would be critical to performance.

Andreas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Loading binary data into the database
Next
From: Jeffery Collins
Date:
Subject: Re: [GENERAL] Some questions on user defined types and functions.