"Blanco, Jose" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend