Re: Brain dump: btree collapsing - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Brain dump: btree collapsing
Date
Msg-id 11687.1045262008@sss.pgh.pa.us
Whole thread Raw
In response to Re: Brain dump: btree collapsing  ("Curtis Faith" <curtis@galtcapital.com>)
List pgsql-hackers
"Curtis Faith" <curtis@galtcapital.com> writes:
>> "Stored in the index"?  And how will you do that portably?  

> Sorry for the lack of rigorous language. I meant that there would be one
> mutex per index stored in the header or internal data structures
> associated with each index somewhere. Probably in the same structure the
> root node reference for each btree is stored.

Hm.  A single lock that must be grabbed for operations anywhere in the
index is a concurrency bottleneck.  But maybe we could avoid that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: client_encoding directive is ignored in postgresql.conf
Next
From: Bruce Momjian
Date:
Subject: Re: location of the configuration files