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