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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel ?erud <zilch(at)home(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What could be the reason for EXTREMELY slow INSERTs?
Date: 2001-04-02 18:55:46
Message-ID: 12954.986237746@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Daniel ?erud <zilch(at)home(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Poul L. Christiansen 2001-04-02 18:56:48 Re: What could be the reason for EXTREMELY slow INSERTs?
Previous Message Steve Wampler 2001-04-02 18:25:38 Repairing bad table?