Re: Insert Performance

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Michael Paesold <mpaesold(at)gmx(dot)at>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Insert Performance
Date: 2002-09-26 00:08:07
Message-ID: Pine.LNX.4.21.0209261006080.3530-100000@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-09-26 00:52:29 Re: compiling client utils under win32 - current 7.3devel
Previous Message Michael Paesold 2002-09-25 23:58:17 Re: Insert Performance