Horton
Menu

Re: NOT LIKE much faster than LIKE?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrea Arcangeli <andrea@cpushare.com>
Cc: Greg Stark <gsstark@mit.edu>, pgsql-performance@postgresql.org
Date: 2006-01-10T15:46:53Z
Lists: pgsql-performance 
Andrea Arcangeli <andrea@cpushare.com> 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