Insert taking too long - Mailing list pgsql-bugs

From Blanco, Jose
Subject Insert taking too long
Date
Msg-id E0217C87D1BA1043AC897ACFA468CEE60148C2F1@ECLUST2-VS3.adsroot.itcs.umich.edu
Whole thread Raw
In response to Re: Postgresql Domain Names  (Linda O <linda@artemiswoman.com>)
Responses Re: Insert taking too long  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

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