From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bill Chandler <billybobc1210@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance degredation at client site
Date: Mon, 31 Jan 2005 12:46:19 -0500
Message-ID: <20887.1107193579@sss.pgh.pa.us> (raw)
In-Reply-To: <20050131171918.20665.qmail@web51410.mail.yahoo.com>
References: <20050131171918.20665.qmail@web51410.mail.yahoo.com>
Bill Chandler <billybobc1210@yahoo.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, billybobc1210@yahoo.com
Subject: Re: Performance degredation at client site
In-Reply-To: <20887.1107193579@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox