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