From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: 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 21:28:30 +0530
Message-ID: <a97c77030604100858h4ef89e92sa6ecdd0aca735edb@mail.gmail.com> (raw)
In-Reply-To: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com>
References: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com>
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 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.
>
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: mallah.rajesh@gmail.com, soni.de@gmail.com
Subject: Re: Takes too long to fetch the data from database
In-Reply-To: <a97c77030604100858h4ef89e92sa6ecdd0aca735edb@mail.gmail.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