Re: Insert taking too long

"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