On Mon, Oct 15, 2012 at 9:24 PM, Deven Thaker <devenmthaker@xxxxxxxxx> 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
