Re: Large Tables/clustering/terrible performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael McAlpine" <mikem(at)vis(dot)oregonian(dot)com>
Cc: jwbaker(at)acm(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Large Tables/clustering/terrible performance
Date: 2001-12-31 22:14:06
Message-ID: 14461.1009836846@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Michael McAlpine" <mikem(at)vis(dot)oregonian(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-12-31 22:23:09 Re: 7.2 changes to varchar truncation
Previous Message Jeffrey W. Baker 2001-12-31 22:04:03 7.2 changes to varchar truncation