| From: | "Glen Parker" <glenebob(at)nwlink(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly |
| Date: | 2004-04-22 21:18:11 |
| Message-ID: | 001301c428af$51773050$0b01a8c0@saturn |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I think that the problems I am seeing are due to using a much
> older version of PostgreSQL. We use 7.1.3 here, because we
> have thoroughly tested it (many thousands of tests are in our
> regression suite). But if I delete too many records, the
> only way I can reclaim the space is to drop the table.
Maybe this problem is related to indexes. Vacuuming does not work on
indexes, so from time to time you have to issue a REINDEX on tables that
have lots of deletions. This is problem is supposed to be going away soon,
or mostly so... I think 7.4 contained an improvement here.
VACUUM FULL really really does reclaim all space in the heap. Try REINDEX
next time.
> We are working with the beta of 7.5 and perhaps it will cure
> all the ills that remain.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-04-22 21:23:35 | Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly |
| Previous Message | Dann Corbit | 2004-04-22 21:15:47 | Has anyone come up with a work-around for the capitalization of non C-locale letters? |