Re: Speeding up DELETEs on table with FKs ...

"Marc G. Fournier" <scrappy@postgresql.org> 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