Hengky Lie <hengkyliwandouw@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