Re: NOT LIKE much faster than LIKE? - Mailing list pgsql-performance

From Tom Lane
Subject Re: NOT LIKE much faster than LIKE?
Date
Msg-id 152.1136908013@sss.pgh.pa.us
Whole thread Raw
In response to Re: NOT LIKE much faster than LIKE?  (Andrea Arcangeli)
Responses Re: NOT LIKE much faster than LIKE?  (Andrea Arcangeli)
List pgsql-performance
Andrea Arcangeli <> writes:
> There's only one preempt near the end, not sure if it would work?

Not with that data, but maybe if you increased the statistics target for
the column to 100 or so, you'd catch enough values to get reasonable
results.

            regards, tom lane

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: NOT LIKE much faster than LIKE?
Next
From: Tom Lane
Date:
Subject: Re: NOT LIKE much faster than LIKE?