Skip site navigation (1) Skip section navigation (2)

Re: Performance degredation at client site

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Chandler <billybobc1210(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance degredation at client site
Date: 2005-01-31 17:46:19
Message-ID: 20887.1107193579@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: PFCDate: 2005-01-31 18:14:48
Subject: Re: Performance degredation at client site
Previous:From: Bill ChandlerDate: 2005-01-31 17:19:18
Subject: Performance degredation at client site

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group