Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] ORDER BY optimisations

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Jackson, DeJuanDate: 1998-10-30 17:23:50
Subject: RE: [HACKERS] Re: [COMMITTERS] 'pgsql/src/include/catalog pg_operator.h'
Previous:From: Bruce MomjianDate: 1998-10-30 17:17:49
Subject: Re: Ready for admin guide and INSTALL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group