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

From Tom Lane
Subject Re: A thought on Index Organized Tables
Date
Msg-id 9638.1266901966@sss.pgh.pa.us
Whole thread Raw
In response to Re: A thought on Index Organized Tables  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: A thought on Index Organized Tables
Re: A thought on Index Organized Tables
List pgsql-hackers
Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp> writes:
> Instead, how about excluding columns in primary keys from table data?

How will you implement "select * from mytable" ?  Or even
"select * from mytable where non_primary_key = something" ?
If you can't do either of those without great expense, I think
a savings on primary-key lookups is not going to be adequate
recompense.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: tie user processes to postmaster was:(Re: [HACKERS] scheduler in core)
Next
From: Bruce Momjian
Date:
Subject: Re: More robust pg_hba.conf parsing/error logging