Fetching large no of data takes lot of time

From: Deven Thaker <devenmthaker(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Fetching large no of data takes lot of time
Date: 2012-10-15 14:58:31
Message-ID: CAH6Xyuk4grfm3ZD4gMeDkHreXimdLfFmEVtxeojv3LS_xXVm-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?
I have not changed any parameters in postgresql.conf, so using default
values.

My PC has RAM of 4 GB (Windows 2003 R2 64 BITS)

Regards
Deven

Browse pgsql-bugs by date

  From Date Subject
Next Message Deven Thaker 2012-10-15 15:02:45 Re: BUG #7592: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder
Previous Message devenmthaker 2012-10-15 14:54:33 BUG #7603: Application takes long time to fetch data from postgresql database