Re: [PERFORM] Heavy write activity on first vacuum of fresh TOASTa

2007-12-14 Thread Matthew
On Fri, 14 Dec 2007, Tom Lane wrote: > Matthew <[EMAIL PROTECTED]> 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.

Re: [PERFORM] Heavy write activity on first vacuum of fresh TOASTa

2007-12-14 Thread Tom Lane
Matthew <[EMAIL PROTECTED]> 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 separ

Re: [PERFORM] Heavy write activity on first vacuum of fresh TOASTa

2007-12-14 Thread Matthew
On Thu, 13 Dec 2007, Simon Riggs wrote: > On Thu, 2007-12-13 at 09:46 -0600, Kevin Grittner wrote: > > Even though there have been no rollbacks, updates, or deletes on this > > table, the vacuum is writing as much as it is reading while dealing > > with the TOAST data. > > Writing hint bits. Annoyi