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

From Zeugswetter Andreas ADI SD
Subject Re: Ye olde drop-the-database-you-just-left problem
Date
Msg-id E1539E0ED7043848906A8FF995BDA579021B2C35@m0143.s-mxs.net
Whole thread Raw
In response to Re: Ye olde drop-the-database-you-just-left problem  (Brian Hurt <bhurt@janestcapital.com>)
Responses Re: Ye olde drop-the-database-you-just-left problem  (Jim Nasby <decibel@decibel.org>)
List pgsql-hackers
> >  However, it suddenly struck me that we could
> >probably make most of the problem go away if we put that same wait
into
> >DROP DATABASE itself --- that is, if we see other backends in the
> >target DB, sleep for a second or two and then recheck before erroring
out.

Yup, waiting in drop database up to 10-30 secs would imho be fine.

Andreas


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: ERROR: index row size 2960 exceeds btree maximum
Next
From: Gregory Stark
Date:
Subject: Re: TOAST usage setting