From: Hemapriya <priyam_1121@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: data corruption
Date: Wed, 28 Sep 2005 12:12:37 -0700 (PDT)
Message-ID: <20050928191237.56381.qmail@web34212.mail.mud.yahoo.com> (raw)
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
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-admin@postgresql.org
Cc: priyam_1121@yahoo.com
Subject: Re: data corruption
In-Reply-To: <20050928191237.56381.qmail@web34212.mail.mud.yahoo.com>
* 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