> OK. Stop and think about what you're telling postgresql to do here.
> You're telling it to cast the field group_id to int8, then compare it to
> 9. How can it cast the group_id to int8 without fetching it? That's
> right, you're ensuring a seq scan. You need to put the int8 cast on the
> other side of that equality comparison, like:
Yeh that one was my fault :) I couldn't remember which way it went and
if 7.4.x had issues with int8 indexes..
Postgresql & php tutorials
In response to
pgsql-performance by date
|Next:||From: email@example.com||Date: 2006-04-26 01:42:04|
|Subject: Re: Hardware: HP StorageWorks MSA 1500|
|Previous:||From: Tom Lane||Date: 2006-04-26 01:19:47|
|Subject: Re: PL/pgSQL Loop Vs. Batch Update |