Re: A thought on Index Organized Tables - Mailing list pgsql-hackers

From Greg Stark
Subject Re: A thought on Index Organized Tables
Date
Msg-id 407d949e1002240923t552a9ab8pafd17000856726c9@mail.gmail.com
Whole thread Raw
In response to Re: A thought on Index Organized Tables  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Responses Re: A thought on Index Organized Tables  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Wed, Feb 24, 2010 at 4:12 PM, Gokulakannan Somasundaram
<gokul007@gmail.com> wrote:
> Sequential scans can be done on IOTs, just scan through the leaf pages.

That doesn't work because when you split an index page any sequential
scan in progress will either see the same tuples twice or will miss
some tuples depending on where the new page is allocated. Vacuum has a
clever trick for solving this but it doesn't work for arbitrarily many
concurrent scans.



-- 
greg


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: A thought on Index Organized Tables
Next
From: Heikki Linnakangas
Date:
Subject: Re: [COMMITTERS] pgsql: Move documentation of all recovery.conf option to a new chapter.