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

Rajesh Kumar Mallah wrote:
>
> what is the query ?
> use LIMIT or a restricting where clause.

You could also use a cursor.

Joshua D. Drake
>
>
> regds
> mallah.
>
> On 4/10/06, *soni de* < soni.de@gmail.com <mailto: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.
>
>


--

             === The PostgreSQL Company: Command Prompt, Inc. ===
       Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
       Providing the most comprehensive  PostgreSQL solutions since 1997
                      http://www.commandprompt.com/