Re: Insert Performance - Mailing list pgsql-hackers

From Gavin Sherry
Subject Re: Insert Performance
Date
Msg-id Pine.LNX.4.21.0209261006080.3530-100000@linuxworld.com.au
Whole thread Raw
In response to Re: Insert Performance  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-hackers
> Only vacuum will reset the insert times to the lowest possible!
> What does the vacuum code do?? :-]

Please see the manual and the extensive discussions on this point in the
archives. This behaviour is well known -- though undesirable. It is an
effect of the multi-version concurrency control system.

Gavin



pgsql-hackers by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: Insert Performance
Next
From: Joe Conway
Date:
Subject: Re: compiling client utils under win32 - current 7.3devel