From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | Hannu Krosing <hannu(at)trust(dot)ee>, David Hartwig <daveh(at)insightdist(dot)com>, Jan Wieck <jwieck(at)debis(dot)com>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] 6.5 beta and ORDER BY patch |
Date: | 1999-05-09 11:55:33 |
Message-ID: | 199905091155.HAA16518@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
It is my assumption this has been applied to 6.5 beta, right?
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hello all,
>
> > -----Original Message-----
> > From: owner-pgsql-hackers(at)postgreSQL(dot)org
> > [mailto:owner-pgsql-hackers(at)postgreSQL(dot)org]On Behalf Of Hannu Krosing
> > Sent: Thursday, February 04, 1999 3:43 AM
> > To: Jan Wieck
> > Cc: hackers(at)postgreSQL(dot)org
> > Subject: Re: [HACKERS] 6.5 beta and ORDER BY patch
> >
>
> [snip]
>
> >
> > After that the reverse index scans, so that the index that are
> > backwards can also be used for sorting.
> > BTW, can this be easily implemented/effective in PostgreSQL or are
> > our btree indexes optimised for forward scans ?
> >
>
> PostgreSQL seems to have the ability to scan Index backward
> because we can execute "fetch backward" command.
> IMHO _bt_first() fucntion used to find first item in a scan should
> be changed to work well in case of backward positioning.
>
> I think this change also gives the partial solution for the problem
> [ [HACKERS] Cursor Movement - Past the End ] reported by
> David Hartwig.
>
> I have a sample code for this change.
> I can send it if someone want to check or test it.
>
> Thanks.
>
> Hiroshi Inoue
> Inoue(at)tpf(dot)co(dot)jp
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 1999-05-09 12:03:16 | Re: [HACKERS] ODMG interface |
Previous Message | Bruce Momjian | 1999-05-09 11:54:58 | Re: [HACKERS] 6.5 beta and ORDER BY patch |