Re: vacuum performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: vacuum performance
Date
Msg-id 20588.1079677100@sss.pgh.pa.us
Whole thread Raw
In response to vacuum performance  (Alan Stange <stange@rentec.com>)
List pgsql-performance
Alan Stange <stange@rentec.com> writes:
> I do a truss on the process and see the output below looping over and
> over.   Note the constant opening and closing of the file 42064889.3.
> Why the open/close cycle as opposed to caching the file descriptor
> somewhere?

This is probably a "blind write".  We've gotten rid of those for 7.5.

            regards, tom lane

pgsql-performance by date:

Previous
From: Alan Stange
Date:
Subject: vacuum performance
Next
From: Tom Lane
Date:
Subject: Re: string casting for index usage