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

Try to run a vacuum on the box with slow inserts (don't know if that
helps, though).

Run a /sbin/hdparm -t <harddisk>, to compare the speed of the harddisks.

HTH,
Poul L. Christiansen

Daniel ?erud wrote:
>
> I have this little test application that compares
> retreiving and inserting data using indexes and not using
> indexes. I have tried this program on two different
> machines. One is a PIII 533 256 meg memory and SCSI. The
> other one is a dual 400 (something) 512 meg memory. The
> thing is that the PII _SELECTS_ faster (this is OK since
> the program uses one thread/process) than the dual 400 but
> inserts is a complete different story.
>
> 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?
>
> Thanks.
>
> Daniel Åkerud
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly