Postgres Pro
Downloads
Home   >   mailing lists

BUG #7603: Application takes long time to fetch data from postgresql database - Mailing list pgsql-bugs

From devenmthaker@gmail.com
Subject BUG #7603: Application takes long time to fetch data from postgresql database
Date
Msg-id E1TNm3t-0000Wp-ME@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7603: Application takes long time to fetch data from postgresql database  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      7603
Logged by:          Deven
Email address:      devenmthaker@gmail.com
PostgreSQL version: 9.0.3
Operating system:   Windows 2003 R2 64 BITS
Description:        =


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, using default values.

My PC has RAM of 4 GB.

pgsql-bugs by date:

Previous
From: daniel.heden@sweco.se
Date:
Subject: BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.
Next
From: Deven Thaker
Date:
Subject: Fetching large no of data takes lot of time