| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Gabriele Turchi <gabriele(dot)turchi(at)l39a(dot)com> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-performance(at)postgresql(dot)org, Marco Colombo <marco(at)esiway(dot)net> |
| Subject: | Re: Big differences in plans between 8.0 and 8.1 |
| Date: | 2006-07-15 20:04:33 |
| Message-ID: | 44B94A51.9050108@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Gabriele Turchi wrote:
> Running an ANALYZE really change the plan, now it is fast as before
> (8.0).
>
> On the production system a VACUUM FULL ANALYZE is run every morning
> after a clean-up, when the "registrazioni" table is empty. During the
> day this table fills up (about 500 record any day), and apparently the
> performances are free-falling very quickly. This behaviour has not
> changed between the old and the new installation.
>
> Can you suggest an easy way to collect and keep up-to-date these
> statistics in a very low-impact way?
>
Why not just periodically (once an hour?) run "ANALYZE registrazioni;"
during the day. This will only update the statistics, and should be very
low impact.
HTH,
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriele Turchi | 2006-07-15 20:22:50 | Re: Big differences in plans between 8.0 and 8.1 |
| Previous Message | Gabriele Turchi | 2006-07-15 19:55:49 | Re: Big differences in plans between 8.0 and 8.1 |