Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A thought on Index Organized Tables
Дата
Msg-id 9638.1266901966@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: A thought on Index Organized Tables  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Ответы Re: A thought on Index Organized Tables  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Re: A thought on Index Organized Tables  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: tie user processes to postmaster was:(Re: [HACKERS] scheduler in core)
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: More robust pg_hba.conf parsing/error logging