On 29.11.2010 18:48, Balamurugan Mahendran wrote:
Thanks, I'll remove it. But I still get down time because of Vacuum(table lock). Is there any other better way to do this?
Non-full vacuum doesn't lock out concurrent access. If you're getting downtime, there's got to be some other explanation.
I don't mind to switch to bigger instance with more Hardware.
Based on the information you've provided, it won't make a difference. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs