pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM Quesition
2+ messages / 2 participants
[nested] [flat]
* VACUUM Quesition
@ 2004-02-05 17:08 Stefan Sturm <mailling@anrath.info>
0 siblings, 1 reply; 2+ messages in thread
From: Stefan Sturm @ 2004-02-05 17:08 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: VACUUM Quesition
@ 2004-02-05 17:22 Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
parent: Stefan Sturm <mailling@anrath.info>
0 siblings, 0 replies; 2+ messages in thread
From: Sam Barnett-Cormack @ 2004-02-05 17:22 UTC (permalink / raw)
To: Stefan Sturm <mailling@anrath.info>; +Cc: pgsql-admin
On Thu, 5 Feb 2004, Stefan Sturm wrote:
> 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?
'full' is an option to vacuum, essentially, as is 'analyze', so there
are four variants (ignoring the freeze option):
vacuum
vacuum analyze
vacuum full
vacuum full analyze
It's all pretty obvious from there.
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-02-05 17:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-05 17:08 VACUUM Quesition Stefan Sturm <mailling@anrath.info>
2004-02-05 17:22 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox