drop database command blocking other connections - Mailing list pgsql-hackers

From Jim Buttafuoco
Subject drop database command blocking other connections
Date
Msg-id 20060503130621.M49004@contactbda.com
Whole thread Raw
Responses Re: drop database command blocking other connections
Re: drop database command blocking other connections
List 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



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Automatic free space map filling
Next
From: Martijn van Oosterhout
Date:
Subject: Re: patch review, please: Autovacuum/Vacuum times via stats.