Bill Chandler <billybobc1210(at)yahoo(dot)com> 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
In response to
pgsql-performance by date
|Next:||From: PFC||Date: 2005-01-31 18:14:48|
|Subject: Re: Performance degredation at client site|
|Previous:||From: Bill Chandler||Date: 2005-01-31 17:19:18|
|Subject: Performance degredation at client site|