Bill Chandler <[EMAIL PROTECTED]> writes:
> Update processes run continually throughout the day in
> which rows are inserted but none deleted.
What about row updates?
> Even seemingly simple commands are taking forever.
> For example:
> select evt_id from event_tbl where evt_id=1;
> takes over a minute to complete.
Since evt_id is a bigint, you need to write that as
select evt_id from event_tbl where evt_id=1::bigint;
or various other locutions that have the same effect. What you have is
a bigint-vs-int comparison, which is not indexable in releases before 8.0.
The same problem is occurring in your other example.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
