drop database command blocking other connections

From: "Jim Buttafuoco" <jim(at)contactbda(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: drop database command blocking other connections
Date: 2006-05-03 13:10:19
Message-ID: 20060503130621.M49004@contactbda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

from time to time I have to drop a very large database (1TB+). The drop database command takes a long time to complete
while its deleting the files. During this time, no one can connect to the database server, ps displays "startup
waiting". This is with Postgresql 7.4. Has this been addressed in 8.1, if not, does anyone have some ideas on how to
speed this up.

thanks
Jim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-05-03 13:54:57 Re: patch review, please: Autovacuum/Vacuum times via stats.
Previous Message Hannu Krosing 2006-05-03 11:34:08 Re: Automatic free space map filling