Postgres Pro
Downloads
Home   >   mailing lists

Re: One source of constant annoyance identified - Mailing list pgsql-general

From P.J. \"Josh\" Rovero
Subject Re: One source of constant annoyance identified
Date
Msg-id 3D1C4B3E.4010708@sonalysts.com
Whole thread Raw
In response to Re: One source of constant annoyance identified  ("Markus Wollny" <Markus.Wollny@computec.de>)
Responses Re: One source of constant annoyance identified  (nconway@klamath.dyndns.org (Neil Conway))
List pgsql-general
Tree view 
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@sonalysts.com    www.sonalysts.com    215 Parkway North
Work: (860)326-3671 or 442-4355                     Waterford CT 06385
***********************************************************************

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: One source of constant annoyance identified
Next
From: Andrew Sullivan
Date:
Subject: Re: Shared Memory Sizing