Dear Kevin, After reading the link you gave to me, changing shared_buffers to 25% (512MB) of available RAM and effective_cache_size to 1500MB (about 75% of available RAM) make the query runs very fast. Postgres only need 1.8 second to display the result.
Thanks a lot ! On Nov 24, 2013, at 11:21 PM, Kevin Grittner wrote: > Hengky Lie <hengkyliwand...@gmail.com> wrote: > >> this query takes long time to process. It takes around 48 seconds >> to calculate about 690 thousand record. > >> Is there any way to make calculation faster ? > > Quite possibly -- that's about 70 microseconds per row, and even > fairly complex queries can often do better than that. You didn't > provide enough information to allow people to help you very > effectively. Please read this page: > > http://wiki.postgresql.org/wiki/SlowQueryQuestions > > I suggest that you post to the pgsql-performance list with more > detail, as suggested on that page. > > -- > Kevin Grittner > EDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
