Re: PG 8.4 and pg_autovacuum functionality

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.