| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Blanco, Jose" <blancoj(at)umich(dot)edu> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Insert taking too long |
| Date: | 2007-11-12 16:49:22 |
| Message-ID: | 7134.1194886162@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Blanco, Jose" <blancoj(at)umich(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-11-12 17:00:45 | Re: BUG #3745: I am unable to load the data in postgresql DB |
| Previous Message | Blanco, Jose | 2007-11-12 16:42:51 | Insert taking too long |