Postgres Pro
Downloads
Home   >   mailing lists

VACUUM Quesition - Mailing list pgsql-admin

From Stefan Sturm
Subject VACUUM Quesition
Date
Msg-id 20040205170839.71DC1D1CB1D@svr1.postgresql.org
Whole thread Raw
In response to Re: R: slow seqscan after vacuum analize  (Andrew Biagioni <andrew.biagioni@e-greek.net>)
Responses Re: VACUUM Quesition  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
List pgsql-admin
Tree view 
Hello,

I have a question about vaccum. There are thre Version of vaccums:
1.) plain vacuum
2.) vacuum analyze
3.) full vacuum

Is it right that a vacuum analyze includes the plain vacuum and the full
vacuum includes the vacuum analyze? And which vacuum locks the tables?

And is there a strategy when to use which vacuum? I think I should do a full
vacuum every night and a vacuum analyze sometimes a day.

Is this OK?

Greetings,
Stefan Sturm

pgsql-admin by date:

Previous
From: "Edoardo Ceccarelli"
Date:
Subject: R: R: slow seqscan after vacuum analize
Next
From: Tom Lane
Date:
Subject: Re: R: R: slow seqscan after vacuum analize