Re: Large Tables/clustering/terrible performance

"Michael McAlpine" <mikem@vis.oregonian.com> writes:
> Seq Scan on table1  (cost=0.00..163277.83 rows=1 width=300)

So you're not getting an index scan.  What locale did you initdb in?
(If it wasn't "C", LIKE can't use the index.)

            regards, tom lane