| From: | Ed Loehr <efl(at)pobox(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Call for alpha testing: planner statistics revisions |
| Date: | 2001-06-21 19:05:12 |
| Message-ID: | 3B324568.9E6CBABE@pobox.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
>
> I have finished a first pass at the planner statistics and cost
> estimation changes that I want to do for 7.2. It's now time to see
> how well the new code does in the real world...
>
> Some highlights of the new code include:
>
> * ANALYZE is now available as a separate command; you can run it without
> also doing a VACUUM. (Of course, VACUUM ANALYZE still works.)
What is the impact of this newly isolated ANALYZE command on the need
and/or frequency for VACUUMs?
I'd like to reduce the frequency of VACUUMs given my understanding has
been that updates/inserts/deletes are a no-no during VACUUMs (that was
6.5.x era hearsay), and we lock people out during VACUUMs (VACUUM
ANALYZE, that is).
Regards,
Ed Loehr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-06-21 20:02:11 | Re: [GENERAL] Call for alpha testing: planner statistics revisions |
| Previous Message | will trillich | 2001-06-21 19:00:10 | Re: newbie primary key problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 2001-06-21 19:07:14 | Re: COPY vs. INSERT |
| Previous Message | John Moore | 2001-06-21 18:32:05 | JDBC Connection State Management with SQL Exceptions (esp Postgresql) |