drop database command blocking other connections

Поиск
Список
Период
Сортировка
От Jim Buttafuoco
Тема drop database command blocking other connections
Дата
Msg-id 20060503130621.M49004@contactbda.com
обсуждение исходный текст
Ответы Re: drop database command blocking other connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: drop database command blocking other connections  ("Tony Wasson" <ajwasson@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Automatic free space map filling
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: patch review, please: Autovacuum/Vacuum times via stats.