| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org, "J(dot)H(dot)M(dot) Dassen (Ray)" <jdassen(at)cistron(dot)nl> |
| Subject: | Re: pg 7.0.2-2 vacuum slowness / loop? (fwd) |
| Date: | 2000-07-17 14:48:55 |
| Message-ID: | 3369.963845335@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> forwards:
> I'm currently encountering problems using postgresql 7.0.2-2 on a potato
> system: PostgreSQL works fine, except that vacuuming seems to loop or take a
> /very/ long time. I'm working on a dual PIII 500 Mhz machine with a
> database of approx. 1.5 million records in a single table. An attempt to
> vacuum the databases on this machine started on friday evening, and still
> hasn't finished.
That does seem like a long time. Do you have a lot of indexes on this
table? Might be worth dropping the indexes, vacuuming, rebuilding
indexes.
Also, run the vacuum with VERBOSE so you can see how far it's getting.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-17 14:51:58 | Re: Logging Help Needed |
| Previous Message | Steve Heaven | 2000-07-17 14:07:01 | ordering of 'where' sub clauses |