« Return to Thread: Postgresql Domain Names

Insert taking too long

by Blanco, Jose :: Rate this Message:

Reply to Author | View in Thread

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.
Any ideas out there?

Thanks!
Jose

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

 « Return to Thread: Postgresql Domain Names