Thread: Index access using multi-column indices

Index access using multi-column indices

From
"Hiroshi Inoue"
Date:
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


Re: [HACKERS] Index access using multi-column indices

From
Vadim Mikheev
Date:
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


RE: [HACKERS] Index access using multi-column indices

From
"Hiroshi Inoue"
Date:
> -----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


Re: [PATCHES] RE: [HACKERS] Index access using multi-column indices

From
Bruce Momjian
Date:
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
 


Re: [PATCHES] Index access using multi-column indices

From
Bruce Momjian
Date:
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