Takes too long to fetch the data from database

From: "soni de" <soni(dot)de(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Takes too long to fetch the data from database
Date: 2006-04-10 07:21:18
Message-ID: 9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2006-04-10 07:55:33 Restore performance?
Previous Message Ahmad Fajar 2006-04-10 06:54:56 Re: serious problems with vacuuming databases