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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
