[HACKERS] 9-key index ? (fwd)
От | Bruce Momjian |
---|---|
Тема | [HACKERS] 9-key index ? (fwd) |
Дата | |
Msg-id | 199909231735.NAA20235@candle.pha.pa.us обсуждение исходный текст |
Список | pgsql-hackers |
I am adding this to the TODO list. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 Hi all, I could create a 9-key index. create table ix9 ( i1 int4, i2 int4, i3 int4, i4 int4, i5 int4, i6 int4, i7 int4, i8 int4, i9 int4, primary key (i1,i2,i3,i4,i5,i6,i7,i8,i9) ); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'ix9_pkey' for table 'ix9' CREATE \d ix9_pkey Table = ix9_pkey +----------------------------------+----------------------------------+----- --+ | Field | Type | Length| +----------------------------------+----------------------------------+----- --+ | i1 | int4 | 4 | | i2 | int4 | 4 | | i3 | int4 | 4 | | i4 | int4 | 4 | | i5 | int4 | 4 | | i6 | int4 | 4 | | i7 | int4 | 4 | | i8 | int4 | 4 | | i9 | int4 | 4 | +----------------------------------+----------------------------------+----- --+ Is it right ? Regards. Hiroshi Inoue Inoue@tpf.co.jp
В списке pgsql-hackers по дате отправления: