Re: Re: 9.2.4: Strange behavior when wildcard is on left side of search string

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ERR ORR <rd0002(at)gmail(dot)com>
Cc: Kevin Grittner <kgrittn(at)ymail(dot)com>, David Johnston <polobo(at)yahoo(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Re: 9.2.4: Strange behavior when wildcard is on left side of search string
Date: 2013-04-07 15:48:19
Message-ID: 21403.1365349699@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

ERR ORR <rd0002(at)gmail(dot)com> writes:
> My understanding from your replies is that this behavior with *b-tree
> indices* is not considered a bug but rather a case of "works as designed",
> yet still and apart from the solution of my particular problem, the fact
> that in 9.2.4 it is so bad that a simple query sometimes does not finish
> after 10+ minutes with incessant disk activity tends to look like a problem
> to me.

It is no better or worse in 9.2.4 than in any prior release.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Bohmer 2013-04-08 15:58:37 Re: BUG #8043: 9.2.4 doesn't open WAL files from archive, only looks in pg_xlog
Previous Message Christopher Browne 2013-04-07 15:45:49 Re: 9.2.4: Strange behavior when wildcard is on left side of search string