| From: | "Michael Paesold" <mpaesold(at)gmx(dot)at> |
|---|---|
| To: | "R(dot) Willmington" <willmington(at)gmx(dot)net>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Update and some verbose output |
| Date: | 2004-09-18 14:09:47 |
| Message-ID: | 008a01c49d89$27eb02d0$d604460a@zaphod |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
R. Willmington wrote:
> In fact, it seems to perform well and removes the deleted records.
> The problem is that the performance of queries against the table is
> as low as it was before i ran VACUUM FULL for the first time in a
> year,
> whereas performance on the staging system with the SAME database and
> the exact same data was dramatically increased.
Have you tried to reindex the table? (\help REINDEX)
If table indexes have grown very big, I think just vacuum full is not
enough. At least you could try and see, if it makes a difference.
Regards,
Michael Paesold
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Federico Alves | 2004-09-18 23:19:50 | The link for the Beta 2 Windows version of 8.0 is not working |
| Previous Message | Peter Eisentraut | 2004-09-18 14:04:10 | Re: allowing users to change the IP-addresses that are allowed to connect to postgresql |