Re: VACUUM Quesition
| От | Sam Barnett-Cormack |
|---|---|
| Тема | Re: VACUUM Quesition |
| Дата | |
| Msg-id | Pine.LNX.4.50.0402051721300.12789-100000@short.lancs.ac.uk обсуждение исходный текст |
| Ответ на | VACUUM Quesition ("Stefan Sturm" <mailling@anrath.info>) |
| Список | 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
В списке pgsql-admin по дате отправления: