| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>, Christophe Pettus <xof(at)thebuild(dot)com> |
| Subject: | Re: "stuck spinlock" |
| Date: | 2013-12-16 14:53:51 |
| Message-ID: | 20131216145351.GE6019@awork2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2013-12-16 09:46:19 -0500, Tom Lane wrote:
> Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> > The multixact fixes in 9.3.2 weren't complete either... (see recent push)
>
> Are they complete now?
Hm. There's two issues I know of left, both discovered in #8673:
- slru.c:SlruScanDirectory() doesn't support long enough
filenames. Afaics that should be a fairly easy fix.
- multixact/members isn't protected against wraparounds, only
multixact/offsets is. That's a pretty longstanding bug though,
although more likely to be hit these days.
Furthermore there's some missing optimizations (like the useless
multixact generation you noted upon in "Update with subselect sometimes
returns wrong result"), but those shouldn't hold up a release.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2013-12-16 15:21:36 | Re: row security roadmap proposal |
| Previous Message | Tom Lane | 2013-12-16 14:46:19 | Re: "stuck spinlock" |