Re: Insert taking too long - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Insert taking too long
Date
Msg-id 7134.1194886162@sss.pgh.pa.us
Whole thread Raw
In response to Insert taking too long  ("Blanco, Jose" <blancoj@umich.edu>)
List pgsql-bugs
"Blanco, Jose" <blancoj@umich.edu> writes:
> Recently, we ran an 'vacummdb --full' on our database, and I'm finding
> that a scrip that use to take just a couple of ours to run, is now
> taking 12 hours to run.  It's a perl script that does a lot of inserting
> into a few tables.  I've tried dropping indices to speed up the inserts,
> but this does not help.  I'm kind of lost as to why this is happening.

This is not a bug.

You might get some help on pgsql-performance, but you'll need to provide
a lot more information about what your script is doing.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Blanco, Jose"
Date:
Subject: Insert taking too long
Next
From: Tom Lane
Date:
Subject: Re: BUG #3745: I am unable to load the data in postgresql DB