| 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: | Whole Thread | Raw Message | 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
| 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) ? |