| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Deven Thaker <devenmthaker(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Application takes longer time to fetch large no of records from Postgresql 9.0.3 |
| Date: | 2012-10-16 04:40:05 |
| Message-ID: | 507CE525.4020109@ringerc.id.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/16/2012 12:24 PM, Deven Thaker wrote:
> 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.
I'm pretty sure I sent you a link that would help you answer that
yourself or write a better question that would make it pratical for
others to help you.
Allow me to repeat myself.
Please read this:
https://wiki.postgresql.org/wiki/Slow_Query_Questions
then follow up with a complete question including exact query text,
EXPLAIN (ANALYZE, BUFFERS) results, etc.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2012-10-16 04:45:52 | Re: Application takes longer time to fetch large no of records from Postgresql 9.0.3 |
| Previous Message | Craig Ringer | 2012-10-16 04:37:16 | SO issue: src/tutorial of 8.3.x fails to compile on Cygwin |