"Dan Armbrust" <daniel.armbrust.list@xxxxxxxxx> writes: > 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? I think you are comparing different PG versions. Recent releases will delay a bit to see if the competing connection disappears. > Is there some way I can control how long it will > block the drop command, waiting for the DB to not be in use? No. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
