Postgres Pro
Downloads
Home   >   mailing lists

Re: Takes too long to fetch the data from database - Mailing list pgsql-performance

From Rajesh Kumar Mallah
Subject Re: Takes too long to fetch the data from database
Date
Msg-id a97c77030604100858h4ef89e92sa6ecdd0aca735edb@mail.gmail.com
Whole thread Raw
In response to Takes too long to fetch the data from database  ("soni de" <soni.de@gmail.com>)
Responses Re: Takes too long to fetch the data from database
List pgsql-performance
Tree view

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.

pgsql-performance by date:

Previous
From: Jesper Krogh
Date:
Subject: Re: Restore performance?
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: Restore performance?