Postgres Pro
Downloads
Home   >   mailing lists

Re: Delete large amount of records and INSERT (with indexes) goes VERY slow - Mailing list pgsql-general

From Tom Lane
Subject Re: Delete large amount of records and INSERT (with indexes) goes VERY slow
Date
Msg-id 3652.1049983204@sss.pgh.pa.us
Whole thread Raw
In response to Delete large amount of records and INSERT (with indexes) goes VERY slow  (Peter Nixon <listuser@peternixon.net>)
Responses Re: Delete large amount of records and INSERT (with indexes) goes VERY slow  (Peter Nixon <listuser@peternixon.net>)
List pgsql-general
Tree view 
Peter Nixon <listuser@peternixon.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

pgsql-general by date:

Previous
From: Himmet Karaman
Date:
Subject: PLEASE HELP ME URGENT about choosing only the ones that i want while entering the data to postgresql with pgaccess on linux or windows or pgadmin II
Next
From: Guy Fraser
Date:
Subject: Re: ANN: EMS PostgreSQL Query and PostgreSQL Extract released