Postgres Pro
Downloads
Home   >   mailing lists

Fetching large no of data takes lot of time - Mailing list pgsql-bugs

From Deven Thaker
Subject Fetching large no of data takes lot of time
Date
Msg-id CAH6Xyuk4grfm3ZD4gMeDkHreXimdLfFmEVtxeojv3LS_xXVm-Q@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: devenmthaker@gmail.com
Date:
Subject: BUG #7603: Application takes long time to fetch data from postgresql database
Next
From: Deven Thaker
Date:
Subject: Re: BUG #7592: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder