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
Thu, 12 Aug 1999 17:51:30 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
Index access using multi-column indices
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

Tue, 17 Aug 1999 09:56:56 +0800
Vadim Mikheev <vadim@krs.ru>
Re: [HACKERS] Index access using multi-column indices
> -----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

Mon, 27 Sep 1999 17:51:28 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
RE: [HACKERS] Index access using multi-column indices
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, Pennsylvania 19026

Mon, 27 Sep 1999 11:38:05 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [PATCHES] RE: [HACKERS] Index access using multi-column indices
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, Pennsylvania 19026

Mon, 27 Sep 1999 14:18:57 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [PATCHES] Index access using multi-column indices