Обсуждение: Index access using multi-column indices
Hello all, Currently,only the first column of multi-column indices is used to find start scan position of Indexscan-s. To speed up finding scan start position,I have changed _bt_first() to use as many keys as possible. I'll attach the patch here. Regards. Hiroshi Inoue Inoue@tpf.co.jp
Hiroshi Inoue wrote: > > Hello all, > > Currently,only the first column of multi-column indices > is used to find start scan position of Indexscan-s. > > To speed up finding scan start position,I have changed > _bt_first() to use as many keys as possible. Nice! Vadim
> -----Original Message----- > From: owner-pgsql-hackers@postgreSQL.org > [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Hiroshi Inoue > Sent: Thursday, August 12, 1999 5:52 PM > To: pgsql-patches > Cc: pgsql-hackers > Subject: [HACKERS] Index access using multi-column indices > > > Hello all, > > Currently,only the first column of multi-column indices > is used to find start scan position of Indexscan-s. > > To speed up finding scan start position,I have changed > _bt_first() to use as many keys as possible. > > I'll attach the patch here. > Seems this isn't committed yet. If there's no objection,I will commit this patch to current tree. Regards. Hiroshi Inoue Inoue@tpf.co.jp
I will apply it today. I am working through my mailbox after a very busy Summer. [Charset iso-8859-1 unsupported, filtering to ASCII...] > > -----Original Message----- > > From: owner-pgsql-hackers@postgreSQL.org > > [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Hiroshi Inoue > > Sent: Thursday, August 12, 1999 5:52 PM > > To: pgsql-patches > > Cc: pgsql-hackers > > Subject: [HACKERS] Index access using multi-column indices > > > > > > Hello all, > > > > Currently,only the first column of multi-column indices > > is used to find start scan position of Indexscan-s. > > > > To speed up finding scan start position,I have changed > > _bt_first() to use as many keys as possible. > > > > I'll attach the patch here. > > > > Seems this isn't committed yet. > If there's no objection,I will commit this patch to current tree. > > Regards. > > Hiroshi Inoue > Inoue@tpf.co.jp > > ************ > > -- 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, Pennsylvania19026
Applied. [Charset iso-8859-1 unsupported, filtering to ASCII...] > Hello all, > > Currently,only the first column of multi-column indices > is used to find start scan position of Indexscan-s. > > To speed up finding scan start position,I have changed > _bt_first() to use as many keys as possible. > > I'll attach the patch here. > > Regards. > > Hiroshi Inoue > Inoue@tpf.co.jp > [Attachment, skipping...] -- 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, Pennsylvania19026