Re: Drop database / database in use question

Поиск
Список
Период
Сортировка
От Dan Armbrust
Тема Re: Drop database / database in use question
Дата
Msg-id 82f04dc40810171017q251a8c26g44042cfc9c7470a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Drop database / database in use question  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Drop database / database in use question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
This is interesting.

On windows, if I attempt to drop a database when I am purposefully
holding a connection open to the DB, it fails immediately - ~ 100 ms.

On linux, if I do the same thing, the drop database command takes
upwards of 4 seconds before it gives up, and says it can't drop the
DB.

Is this expected?  Is there some way I can control how long it will
block the drop command, waiting for the DB to not be in use?

Thanks,

Dan

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM PANIC: corrupted item pointer
Следующее
От: brian
Дата:
Сообщение: Re: Question about NOT NULL and default values.