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?