Re: [HACKERS] ORDER BY optimisations - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] ORDER BY optimisations
Date
Msg-id 199810301719.MAA10453@candle.pha.pa.us
Whole thread Raw
In response to ORDER BY optimisations  (Hannu Krosing <hannu@trust.ee>)
List 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@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
 


pgsql-hackers by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [HACKERS] Re: [COMMITTERS] 'pgsql/src/include/catalog pg_oper ator.h'
Next
From: Bruce Momjian
Date:
Subject: Re: Ready for admin guide and INSTALL