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

From Gokulakannan Somasundaram
Subject Re: A thought on Index Organized Tables
Date
Msg-id 9362e74e1002241113k185eadfasc5ae9e7164fe243e@mail.gmail.com
Whole thread Raw
In response to Re: A thought on Index Organized Tables  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
It might be slightly easier given the assumption that you only want to
scan leaf tuples.

But there's an additional problem I didn't think of before. Currently
we optimize index scans by copying all relevant tuples to local memory
so we don't need to hold an index lock for an extended time or spend a
lot of time relocking and rechecking the index for changes. That
wouldn't be possible if we needed to get visibility info from the page
since we would need up-to-date information.


We should solve this issue in the same way, of how we proceed with the index only quals, in current index-only scans.

Gokul.
 

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: A thought on Index Organized Tables
Next
From: Simon Riggs
Date:
Subject: Re: pg_stop_backup does not complete