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

Re: One source of constant annoyance identified

From: "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com>
To: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: One source of constant annoyance identified
Date: 2002-06-28 11:40:46
Message-ID: 3D1C4B3E.4010708@sonalysts.com (view raw or flat)
Thread:
Lists: pgsql-general
LIKE '%dfjdsklfdfjdklfjds' is what is killing you.

LIKE 'sdfdklf%' can be indexed, but the leading wildcard
forces an index search.

Markus Wollny wrote:
> Hi!
> 
> It seems I found one of the queries which suck up memory as if there
> were terabytes available.

-- 
P. J. "Josh" Rovero                                 Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com    www.sonalysts.com    215 Parkway North
Work: (860)326-3671 or 442-4355                     Waterford CT 06385
***********************************************************************




In response to

Responses

pgsql-general by date

Next:From: Laurent DupervalDate: 2002-06-28 12:22:07
Subject: Re: How should I do this?
Previous:From: Markus WollnyDate: 2002-06-28 11:25:16
Subject: Re: One source of constant annoyance identified

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