"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> 'k, now that I've seen the error of my ways *groan* I've gone back
> through, and checked for what is referencing that table, and there is only
> one place that is, and it does have an INDEX:
>> explain analyze select * from table where raw_id = 20722;
> QUERY PLAN
> -----------------------------------------------------------------------------------------------------------------------------------
> Index Scan using ind_raw_id on table (cost=0.00..3.09 rows=1 width=122) (actual
> time=0.33..0.33 rows=0 loops=1)
> Index Cond: (raw_id = 20722::numeric)
> Total runtime: 0.37 msec
"numeric", hm? Is the referenced column also of type numeric?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
