X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 844788B9B26 for ; Mon, 31 Jan 2005 18:34:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30542-01 for ; Mon, 31 Jan 2005 18:34:04 +0000 (GMT) Received: from web51404.mail.yahoo.com (web51404.mail.yahoo.com [206.190.38.183]) by svr1.postgresql.org (Postfix) with SMTP id 1F6B08BA0AC for ; Mon, 31 Jan 2005 18:32:02 +0000 (GMT) Received: (qmail 59939 invoked by uid 60001); 31 Jan 2005 18:32:00 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=LaPC7+uhv2mRWpLjtTZYDF7C8eESB9LtHIO+BpDuOtn50UBUK8p8rADxKJBZLZio7ePM/u4KGj50h47MlWknZqRPXOY9bHQ5wFb+8mGTZKJdzSzHIqtplnfaeMvNAzUPKQDurFAicHAyE+Pnw2kPVV3KcGv1f/RgwILRnkbCm58= ; Message-ID: <20050131183200.59937.qmail@web51404.mail.yahoo.com> Received: from [192.88.67.254] by web51404.mail.yahoo.com via HTTP; Mon, 31 Jan 2005 10:32:00 PST Date: Mon, 31 Jan 2005 10:32:00 -0800 (PST) From: Bill Chandler Subject: Re: Performance degredation at client site To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <20887.1107193579@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.796 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200501/635 X-Sequence-Number: 10325 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 wrote: > Bill Chandler 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