From: Joshua D. Drake <jd@commandprompt.com>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: soni de <soni.de@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Takes too long to fetch the data from database
Date: Mon, 10 Apr 2006 11:20:04 -0700
Message-ID: <443AA1D4.9010308@commandprompt.com> (raw)
In-Reply-To: <a97c77030604100858h4ef89e92sa6ecdd0aca735edb@mail.gmail.com>
References: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com>
<a97c77030604100858h4ef89e92sa6ecdd0aca735edb@mail.gmail.com>
Rajesh Kumar Mallah wrote:
>
> what is the query ?
> use LIMIT or a restricting where clause.
You could also use a cursor.
Joshua D. Drake
>
>
> regds
> mallah.
>
> On 4/10/06, *soni de* < soni.de@gmail.com <mailto: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 is 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.
>
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.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-performance@postgresql.org
Cc: jd@commandprompt.com, mallah.rajesh@gmail.com, soni.de@gmail.com
Subject: Re: Takes too long to fetch the data from database
In-Reply-To: <443AA1D4.9010308@commandprompt.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