On Fri, Jul 22, 2005 at 10:02:55 -0400,
Oren Mazor <oren.mazor@gmail.com> wrote:
> Hi all, I'm doing some database optimization work right now, and I'm
> wondering, is there any way to remove the dead tuple functionality? Right
> now I have a vacuum run regularly, but if there was some way I could just
> get rid of the whole problem, that would be great.
What problem are you trying to solve?
The way Postgres implements MVCC leaves deleted tuples for later clean up
after they aren't visible to any currently open transaction. This clean up
is done with vacuum.
