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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
