X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 024DD11F61B9
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 12:58:40 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: 0.12
X-Spam-Level: 
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.119, HTML_MESSAGE=0.001]
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id dFtevrlPa1dO
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 12:58:34 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.185])
	by postgresql.org (Postfix) with ESMTP id 1E4B211F60AF
	for <pgsql-performance@postgresql.org>;
	Mon, 10 Apr 2006 12:58:33 -0300 (ADT)
Received: by nproxy.gmail.com with SMTP id p77so631503nfc
	for <pgsql-performance@postgresql.org>;
	Mon, 10 Apr 2006 08:58:32 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=QWZH1b8nBuBVEezJEFe357VBhaXdbkaLVeOJbJhKXPuhgJu0N4T2xwMbNLdOhYh0u8Y69a8O7Tux39AZSJD/MLkZCpoawNN38iop/RAxs898MpzwXoTBbB5JnBHw8s1WHw5TjWEMoCAbt94KnWs+eqLzv2nZgGJZWvhfsSMjris=
Received: by 10.48.246.1 with SMTP id t1mr794689nfh;
	Mon, 10 Apr 2006 08:58:31 -0700 (PDT)
Received: by 10.49.27.16 with HTTP; Mon, 10 Apr 2006 08:58:30 -0700 (PDT)
Message-ID: <a97c77030604100858h4ef89e92sa6ecdd0aca735edb@mail.gmail.com>
Date: Mon, 10 Apr 2006 21:28:30 +0530
From: "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
To: "soni de" <soni.de@gmail.com>
Subject: Re: Takes too long to fetch the data from database
Cc: pgsql-performance@postgresql.org
In-Reply-To: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_24642_2233583.1144684710975"
References: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com>
X-Archive-Number: 200604/208
X-Sequence-Number: 18292

------=_Part_24642_2233583.1144684710975
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

what is the query ?
use LIMIT or a restricting where clause.


regds
mallah.

On 4/10/06, soni de <soni.de@gmail.com> wrote:
>
> Hello,
>
> I have difficulty in fetching the records from the database.
> Database table contains more than 1 GB data.
> For fetching the records it is taking more the 1 hour and that's why it i=
s
> slowing down the performance.
> please provide some help regarding improving the performance and how do I
> run query so that records will be fetched in a less time.
>

------=_Part_24642_2233583.1144684710975
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br>what is the query ?<br>use LIMIT or a restricting where clause.<br><br>=
<br>regds<br>mallah.<br><br><div><span class=3D"gmail_quote">On 4/10/06, <b=
 class=3D"gmail_sendername">soni de</b> &lt;<a href=3D"mailto:soni.de@gmail=
.com">
soni.de@gmail.com</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" st=
yle=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex=
; padding-left: 1ex;"><div style=3D"direction: ltr;"><div>Hello,</div>
<div>&nbsp;</div>
<div>I have difficulty in fetching the records from the database.</div>
<div>Database table contains more than 1 GB data.</div>
<div>For fetching the records it is taking more the 1 hour and that's why i=
t is slowing down the performance.</div>
<div>please provide some help regarding improving the performance and how d=
o I run query so that records will be fetched in a less time.</div>

</div></blockquote></div><br>

------=_Part_24642_2233583.1144684710975--