Re: [HACKERS] Anyone working on optimizing subset min/max queries?

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Anyone working on optimizing subset min/max queries?
Date: 1998-07-13 21:31:34
Message-ID: 199807132131.RAA28670@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> For now, I can live with scanning all the table entries, but it would be
> nice to know that someone is working on this and it'll be there by the
> time my tables get huge ;-). I see something about
> * Use indexes in ORDER BY, min(), max()(Costin Oproiu)
> in the TODO list, but is this actively being worked on, and will it
> solve my problem or just handle simpler cases?
>
> Alternatively, is there a better way to do predecessor/successor
> queries in SQL?

Costin is not working on it currently, and I have removed his name from
the item. I know of no one working on it, though it is requested every
so often.

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-07-13 21:50:01 Re: [HACKERS] Sequence objects have no global currval operator?
Previous Message Tom Lane 1998-07-13 20:53:47 Anyone working on optimizing subset min/max queries?