Hengky Lie <hengkyliwandouw@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
