Re: Reduce pinning in btree indexes - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Reduce pinning in btree indexes
Date
Msg-id 87pp8v62bf.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Reduce pinning in btree indexes  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
>>>>> "Kyotaro" == Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> writes:
Kyotaro> Anyway I'm sorry but I have left my dev env and cannot haveKyotaro> time till next week.

The point is moot; rather than try and explain it further I did the test
myself, and the performance penalty of disabling mark/restore is
substantial, on the order of 30%, so that's a non-starter. (I was a bit
surprised that it was so bad...)

-- 
Andrew (irc:RhodiumToad)



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Reduce pinning in btree indexes
Next
From: Marc Cousin
Date:
Subject: star schema and the optimizer