Postgres Pro
Downloads
Home   >   mailing lists

Re: What could be the reason for EXTREMELY slow INSERTs? - Mailing list pgsql-general

From Tom Lane
Subject Re: What could be the reason for EXTREMELY slow INSERTs?
Date
Msg-id 12954.986237746@sss.pgh.pa.us
Whole thread Raw
In response to What could be the reason for EXTREMELY slow INSERTs?  (Daniel ?erud <zilch@home.se>)
List pgsql-general
Tree view 
Daniel ?erud <zilch@home.se> writes:
> 10000 inserts takes 665 seconds on the PIII 533, while on
> the dual 400 it takes about 13 seconds (*GULP!*).

Maybe postmaster running with -F on one system but not the other?
Or referential integrity checks defined on one table and
not the other?

            regards, tom lane

pgsql-general by date:

Previous
From: Daniel ?erud
Date:
Subject: What could be the reason for EXTREMELY slow INSERTs?
Next
From: "Poul L. Christiansen"
Date:
Subject: Re: What could be the reason for EXTREMELY slow INSERTs?