9-key index ?
От | Hiroshi Inoue |
---|---|
Тема | 9-key index ? |
Дата | |
Msg-id | 000401becda0$17deee60$2801007e@cadzone.tpf.co.jp обсуждение исходный текст |
Список | pgsql-hackers |
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 по дате отправления: