Re: "stuck spinlock" - Mailing list pgsql-hackers

From Andres Freund
Subject Re: "stuck spinlock"
Date
Msg-id 20131216145351.GE6019@awork2.anarazel.de
Whole thread Raw
In response to Re: "stuck spinlock"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "stuck spinlock"
List pgsql-hackers
On 2013-12-16 09:46:19 -0500, Tom Lane wrote:
> Andres Freund <andres@2ndquadrant.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "stuck spinlock"
Next
From: Craig Ringer
Date:
Subject: Re: row security roadmap proposal