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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to