Tom, Thank you! I will have the client try that. What about the event_tbl_evt_id_key index question. Could that also be causing me difficulties? Should I periodically reindex it?
thanks, Bill --- Tom Lane <[EMAIL PROTECTED]> wrote: > 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 > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
