| From: | Mary Edie Meredith <maryedie(at)osdl(dot)org> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Rod Taylor <rbt(at)rbt(dot)ca>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>, OSDL - DB General <osdldbt-general(at)lists(dot)sourceforge(dot)net> |
| Subject: | Re: [GENERAL] how to get accurate values in pg_statistic |
| Date: | 2003-09-05 00:01:56 |
| Message-ID: | 1062720115.6854.3662.camel@ibm-e.pdx.osdl.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
The documentation lead us to believe that it would not, but we are
testing just the same (at least checking that the pg_statistics are the
same after each load and VACUUM FULL ANALYZE). Will report back.
On Thu, 2003-09-04 at 16:50, Neil Conway wrote:
> On Thu, 2003-09-04 at 13:46, Rod Taylor wrote:
> > Run a VACUUM FULL ANALYZE between runs. This will force a full scan of
> > all data for stats
>
> It will? Are you sure about that?
>
> -Neil
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Mary Edie Meredith <maryedie(at)osdl(dot)org>
Open Source Development Lab
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-09-05 00:29:11 | Re: [GENERAL] how to get accurate values in pg_statistic |
| Previous Message | Neil Conway | 2003-09-04 23:50:24 | Re: [GENERAL] how to get accurate values in pg_statistic |