Re: Heavy write activity on first vacuum of fresh TOASTa - Mailing list pgsql-performance

From Tom Lane
Subject Re: Heavy write activity on first vacuum of fresh TOASTa
Date
Msg-id 8116.1197649369@sss.pgh.pa.us
Whole thread Raw
In response to Re: Heavy write activity on first vacuum of fresh TOASTa  (Matthew <matthew@flymine.org>)
Responses Re: Heavy write activity on first vacuum of fresh TOASTa
List pgsql-performance
Matthew <matthew@flymine.org> writes:
> Interesting thread. Now, I know absolutely nothing about how the data is
> stored, but it strikes me as being non-optimal that every single block on
> the disc needs to be written again just to update some hint bits. Could
> those bits be taken out into a separate bitmap stored somewhere else?

You are trying to optimize the wrong thing.  Making vacuum cheaper at
the cost of making every tuple lookup more expensive is not going to
be a win.

            regards, tom lane

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: viewing source code
Next
From: Matthew
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOASTa