X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D1BA2D9A91
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 28 Sep 2005 16:12:41 -0300 (ADT)
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 80447-01
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 28 Sep 2005 19:12:37 +0000 (GMT)
Received: from web34212.mail.mud.yahoo.com (web34212.mail.mud.yahoo.com
	[66.163.178.127])
	by svr1.postgresql.org (Postfix) with SMTP id 4D229D9910
	for <pgsql-admin@postgresql.org>; Wed, 28 Sep 2005 16:12:37 -0300 (ADT)
Received: (qmail 56383 invoked by uid 60001); 28 Sep 2005 19:12:37 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=LrFYM7Y3DiXKn1+c24lv3BqCUgYkhHD7jYZb/yGD+XNwvWR060zp5FQpv8+I1oOuk+jMW8inhSHvmiZhNpF/3cM4LKS5mMm4UYk+tL3GM/dfpc6QbZ41QnaYF195b1HMkw443Jht7Pjma4pyzx7eoUhg98jHMMlQTQoQe311Dak=
	;
Message-ID: <20050928191237.56381.qmail@web34212.mail.mud.yahoo.com>
Received: from [209.21.108.34] by web34212.mail.mud.yahoo.com via HTTP;
	Wed, 28 Sep 2005 12:12:37 PDT
Date: Wed, 28 Sep 2005 12:12:37 -0700 (PDT)
From: Hemapriya <priyam_1121@yahoo.com>
Subject: data corruption
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.293 required=5 tests=[AWL=0.403,
	DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516]
X-Spam-Level: *
X-Archive-Number: 200509/310
X-Sequence-Number: 19047

Hi,

I have a query that runs fine for one set of data and
not for another.

In the following query, all the columns used in a
where
clause are indexed. If i use this for the
origindbs('02','05','06','07') except '04', it works
fine.
when i look for the data from origindb "04" it just
run for 2 hours. 

"select count(*) from qpassextrequest a,request b
where a.requestFK=b.uid and a.origindb='04' and
a.origindb=b.origindb and b.enteredon >='2005-09-28'
and b.enteredon < '2005-09-29'"

What could be the reason.. Can that be a index or data
corruption? If so, rebuiding the index will solve the
problem?

Any hint is appreciated.

Thanks
Priya




		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com