Re: Application takes longer time to fetch large no of records from Postgresql 9.0.3

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Deven Thaker <devenmthaker(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Application takes longer time to fetch large no of records from Postgresql 9.0.3
Date: 2012-10-16 07:34:43
Message-ID: CAKt_Zfv4TJsDNbb6RwQeYfiiLMj7jpVBeGWHLQzKCqVf_2gugg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 15, 2012 at 9:24 PM, Deven Thaker <devenmthaker(at)gmail(dot)com>wrote:

> Hi,
> My application takes longer time (we see time out even) when data to be
> fetched from Postgresql 9.0.3 is around 1900000 records. I am doing an
> improvement at application level, but from database side any performance
> tuning do i need to do?
>

When you say "fetched" do you mean the select query takes a long time, or
that fetch operations on a cursor get slow after a certain point?

Best Wishes,
Chris Travers

>
> Regards
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Maximilian Tyrtania 2012-10-16 07:44:03 return query execute SQL-problem
Previous Message Raghavendra 2012-10-16 05:49:26 Re: Who is LISTENing?