A next logical step after index-only scans? - Mailing list pgsql-general

From Mike Christensen
Subject A next logical step after index-only scans?
Date
Msg-id CABs1bs1vbeqr3GW_jGQDAsfi24cb2aOHTfsm29Vqyoh=C0s7DA@mail.gmail.com
Whole thread Raw
List pgsql-general
Now that 9.2 supports index-only scans, I'm curious what possibilities
this opens up in the future.

It seems to me that the next logical step is to allow a user to put
all columns into the index, at which point you would no longer even
need the heap table.  Oracle calls this "index-organized tables", and
this offers a lot of benefits for tables with only one index.

Any thoughts on this, or is it on the road map?  Thanks!

Mike


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: "Too far out of the mainstream"
Next
From: "Kevin Grittner"
Date:
Subject: Re: "Too far out of the mainstream"