On Tue, 28 Apr 2009 15:40:22 +0530 Dhaval Rami wrote: > No other process/query is accessing this table until rotation is done. Are you sure? Not even VACUUM? Look into the pg_locks system table to find out, if another connection is accessing the table. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
