Re: Heavy write activity on first vacuum of fresh TOASTa

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Matthew <matthew@xxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux