Re: What could be the reason for EXTREMELY slow INSERTs?

Daniel ?erud wrote:
>
> 10000 inserts takes 665 seconds on the PIII 533, while on
> the dual 400 it takes about 13 seconds (*GULP!*). I have
> done a clean reinstallation (dpkg --purge postgresql, apt-
> get install postgresql) and tried it again. Same results.
> Do you guys know what could be the reason?

Are you running the same version on each machine? There was a discussion
recently where the first thousand inserts were very fast, the next
thousand fast, the next thousand acceptable...  until it grinds to a halt.

I think it was patched before 7.1RC1 - check the list archives for
details on the discussion.

Oh - you don't have constraints on the one but not the other, do you?

- Richard Huxton