From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | hannu(at)trust(dot)ee (Hannu Krosing) |
Cc: | jwieck(at)debis(dot)com, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] ORDER BY optimisations |
Date: | 1998-10-30 17:19:40 |
Message-ID: | 199810301719.MAA10453@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Hallo Jan,
>
> Do I remember right that your pathes to speed up ORDER BYs (by
> omitting them when not needed) did not make it into 6.4 .
>
> If that is the case, are they available anywhere ?
>
> I really need them (fast) for my new project.
LIMIT will probably be added to 6.4.1. Queries that use '%text%' can
not use indexes because they are not anchored at the beginning.
fulltextindex is in contrib for those cases.
--
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 | Jackson, DeJuan | 1998-10-30 17:23:50 | RE: [HACKERS] Re: [COMMITTERS] 'pgsql/src/include/catalog pg_oper ator.h' |
Previous Message | Bruce Momjian | 1998-10-30 17:17:49 | Re: Ready for admin guide and INSTALL |