| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
| Cc: | kishore(dot)sainath(at)gmail(dot)com, pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: A tale of two similar databases |
| Date: | 2006-01-19 22:53:14 |
| Message-ID: | 1137711193.25500.154.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2006-01-19 at 16:46, Michael Glaesemann wrote:
> On Jan 18, 2006, at 14:17 , kishore(dot)sainath(at)gmail(dot)com wrote:
>
> > What are the benefits of the VACUUM command in PostgreSQL?
>
> The docs have quite a bit of information on this. For a start, take a
> look at:
> http://www.postgresql.org/docs/current/interactive/
> maintenance.html#ROUTINE-VACUUMING
>
> Recently, some people of expressed that the material on autovacuum
> may be misleading. The other material should give you enough
> background, however.
>
> For some information on ANALYZE, see:
> http://www.postgresql.org/docs/current/interactive/sql-analyze.html
It's not misleading so much as just incomplete and a little hard for the
beginners to wrap their brains around...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-01-19 22:58:35 | Re: No heap lookups on index |
| Previous Message | Jeremy Drake | 2006-01-19 22:50:39 | Re: No heap lookups on index |