Re: Ye olde drop-the-database-you-just-left problem - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Ye olde drop-the-database-you-just-left problem
Date
Msg-id 200705301303.10150.josh@agliodbs.com
Whole thread Raw
In response to Re: Ye olde drop-the-database-you-just-left problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Ye olde drop-the-database-you-just-left problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

> Even if we had a semaphore of the sort you suggest, I doubt people would
> want DROP DATABASE to wait indefinitely.  The real question here is how
> long is it reasonable for DROP DATABASE to wait before failing ...

10 to 15 seconds, I'd say.  Is that going to be long enough for backends to 
release, assuming the DB isn't under extreme load?

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Padding on 64-bit
Next
From: Bruce Momjian
Date:
Subject: Re: Padding on 64-bit