Takes too long to fetch the data from database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Takes too long to fetch the data from database
From: "soni de" <soni.de@xxxxxxxxx>
Date: Mon, 10 Apr 2006 12:51:18 +0530

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.

Follow-Ups:
- Re: Takes too long to fetch the data from database
  - From: Rajesh Kumar Mallah

Prev by Date: Re: serious problems with vacuuming databases
Next by Date: Re:
Previous by thread: slow "IN" clause
Next by thread: Re: Takes too long to fetch the data from database
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux