What could be the reason for EXTREMELY slow INSERTs?

From: Daniel ?erud <zilch(at)home(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: What could be the reason for EXTREMELY slow INSERTs?
Date: 2001-04-02 18:23:35
Message-ID: 986235815.163zilch@home.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wampler 2001-04-02 18:25:38 Repairing bad table?
Previous Message ADBAAMD 2001-04-02 18:12:19 Re: Can I get the default value for an attribute ( field) ?