Re: Delete large amount of records and INSERT (with indexes) goes VERY slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Nixon <listuser(at)peternixon(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Delete large amount of records and INSERT (with indexes) goes VERY slow
Date: 2003-04-10 14:00:04
Message-ID: 3652.1049983204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Nixon <listuser(at)peternixon(dot)net> writes:
> Yes. But that still doesn't explain the speed. I am not joking when I said I
> was getting only ONE INSERT every 30 seconds - 1 minute!!!

The insertion itself couldn't possibly take that long; the problem had
to be in auxiliary operations invoked by the insert. Do you have any
triggers on that table? Any foreign references to or from it? What
indexes are on the table?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Fraser 2003-04-10 14:36:47 Re: ANN: EMS PostgreSQL Query and PostgreSQL Extract released
Previous Message hetzel.devel 2003-04-10 13:44:57 Programms working on a PostgreSQL database written in C++?