Postgres Pro
Downloads
Home   >   mailing lists

Application takes longer time to fetch large no of records from Postgresql 9.0.3 - Mailing list pgsql-general

From Deven Thaker
Subject Application takes longer time to fetch large no of records from Postgresql 9.0.3
Date
Msg-id CAH6Xyu=jWcpY18LMd-Qrp_fQrQuCrKQ3HYYz5WQ0LGNS3p8dBw@mail.gmail.com
Whole thread Raw
Responses Re: Application takes longer time to fetch large no of records from Postgresql 9.0.3  (Craig Ringer <ringerc@ringerc.id.au>)
Re: Application takes longer time to fetch large no of records from Postgresql 9.0.3  (John R Pierce <pierce@hogranch.com>)
Re: Application takes longer time to fetch large no of records from Postgresql 9.0.3  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
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.

Any recommendations to improve the performance.

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

Regards

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using incorrect default-value type
Next
From: Craig Ringer
Date:
Subject: SO issue: src/tutorial of 8.3.x fails to compile on Cygwin