From: soni de <soni.de@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Takes too long to fetch the data from database
Date: Mon, 10 Apr 2006 12:51:18 +0530
Message-ID: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com> (raw)
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: soni.de@gmail.com
Subject: Re: Takes too long to fetch the data from database
In-Reply-To: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@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