| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ed Loehr <efl(at)pobox(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Call for alpha testing: planner statistics revisions |
| Date: | 2001-06-21 20:02:11 |
| Message-ID: | 22538.993153731@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Ed Loehr <efl(at)pobox(dot)com> writes:
> Tom Lane wrote:
>> * 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?
None really. By the time 7.2 is out, I expect we will also have a
more lightweight form of VACUUM, and so running VACUUM ANALYZE as a
reasonably frequent background operation will still be the norm.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis | 2001-06-21 20:17:55 | Shared Buffers |
| Previous Message | Ed Loehr | 2001-06-21 19:05:12 | Re: [GENERAL] Call for alpha testing: planner statistics revisions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-06-21 20:28:51 | Re: COPY vs. INSERT |
| Previous Message | D'Arcy J.M. Cain | 2001-06-21 19:07:14 | Re: COPY vs. INSERT |