| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Marcelo <pglists(at)zeroaccess(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG 8.4 and pg_autovacuum functionality |
| Date: | 2009-10-14 23:11:32 |
| Message-ID: | 20091014231132.GG4902@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Marcelo wrote:
> Hello,
>
> Since pg_autovacuum no longer exits on PG 8.4 and it seems that one
> now needs to provide the storage parameters during CREATE TABLE or
> later on with an ALTER TABLE.
> Will that ALTER TABLE block anything going on that table until it's
> finished ? I assume not since no table data is actually being
> rewritten.
It will block until it is finished (just like any other ALTER TABLE),
but unless there's something else blocking the table for a long time, it
should be very short. No data is being rewritten.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | el dorado | 2009-10-15 06:02:11 | Re: could not open process token: error code 5 |
| Previous Message | Christophe Pettus | 2009-10-14 22:53:33 | SFPUG: Video from "Statistics and Postgres -- How the Planner Sees Your Data" Now on Vimeo |