Re: Insert Performance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Insert Performance
Date
Msg-id 525.1033010112@sss.pgh.pa.us
Whole thread Raw
In response to Re: Insert Performance  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-hackers
"Michael Paesold" <mpaesold@gmx.at> writes:
> Only vacuum will reset the insert times to the lowest possible!
> What does the vacuum code do?? :-]

It removes dead tuples.  Dead tuples can only arise from update or
delete operations ... so you have not been telling us the whole
truth.  An insert-only test would not have this sort of behavior.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: compiling client utils under win32 - current 7.3devel
Next
From: Joe Conway
Date:
Subject: Re: compiling client utils under win32 - current 7.3devel