Re: Drop database / database in use question

From: "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "pgsql general" <pgsql-general(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Drop database / database in use question
Date: 2008-10-17 17:17:41
Message-ID: 82f04dc40810171017q251a8c26g44042cfc9c7470a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2008-10-17 17:18:13 Re: Drop database / database in use question
Previous Message Tom Lane 2008-10-17 17:11:16 Re: VACUUM PANIC: corrupted item pointer