John R Pierce <pierce@xxxxxxxxxxxx> writes: > On 7/7/2014 2:14 PM, Prabhjot Sheena wrote: >> i will run full vacuum than and see how it goes. > do make sure there aren't any OLD pending transactions hanging around. Not only regular transactions, but prepared transactions: select * from pg_prepared_xacts; 8.3 was the last release in which max_prepared_transactions was nonzero by default, thereby allowing people to shoot themselves in the foot this way without having taken off the safety first :-( regards, tom lane
