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 pr
Do I understand correctly, however, that when you
create a unique SERIAL column an index is
automatically created on that column? If so, does
that sound like a possible culprit? We are not doing
any reindexing on that index at all. Could it be
suffering from index bloat? Do we need to
periodic
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
Hello,
Client is seeing continual performance degradation on
updates and queries from a large database. Any help
appreciated.
Client is using PostgreSQL 7.4.2 on Sparcv9 650MHZ
cpu, 2GB Ram, running Solaris.
We have the following tables:
EVENT_TBL
evt_id bigserial, unique
d1 n
