"David G. Johnston" <david.g.johns...@gmail.com> writes: > Given that we have already heard about 3 separate minor release regressions > in the most recent update I'm putting forth for discussion whether an > off-schedule release should be done. I probably wouldn't care as much if > it wasn't for the fact that the same release fixes two CVEs.
The release team had a discussion about this. We're leaning towards not doing anything out of the ordinary, but are open to public input. To recap a bit: Actually there are four known regressions, because there are two different CREATE TABLE LIKE bugs: * CREATE TABLE LIKE gets confused if new table masks old one (see f7f83a55b) * CREATE TABLE LIKE fails to handle a self-referential foreign key defined in the CREATE, if it depends on an index imported by LIKE (see 97390fe8a) * psql \c with a connstring containing a password ignores the password (see 7e5e1bba0) * LISTEN/NOTIFY can fail to empty its SLRU queue in v12 and earlier (see 9c83b54a9) We felt that the first three of these are at best minor annoyances. The LISTEN/NOTIFY issue is potentially more serious, in that it could cause a service outage for a site that makes heavy use of NOTIFY. However, the race is between two listeners, so in the common (I think) usage pattern of only one listener there's no issue. Even if you hit the race condition, you don't have a problem until 8GB more NOTIFY traffic has been sent, which seems like a lot. The complainants in that bug report indicated they'd overrun that amount in a week or two, but that seems like unusually heavy usage. The other aspect that seems to mitigate the seriousness of the LISTEN/NOTIFY issue is that a server restart is enough to clear the queue. Given that you'd also need a server restart to install a hypothetical off-cycle release, it's easy to see that there's no benefit except to sites that anticipate logging more than 16GB of NOTIFY traffic (and thus needing two or more restarts) before February. So we are leaning to the position that the severity of these issues doesn't justify the work involved in putting out an off-cycle release. But if there are people out there with high-NOTIFY-traffic servers who would be impacted, please speak up! (BTW, the calendar is also a bit unfriendly to doing an off-cycle release. It's probably already too late to plan a Dec 10 release, and by the week after that a lot of people will be in holiday mode. If you start thinking about January, it's not clear why bother, since we'll have minor releases in February anyway.) regards, tom lane