Takes too long to fetch the data from database - Mailing list 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.