| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Hengky Lie <hengkyliwandouw(at)gmail(dot)com>, PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Query runs slow |
| Date: | 2013-11-24 15:21:09 |
| Message-ID: | 1385306469.35533.YahooMailNeo@web162901.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hengky Lie <hengkyliwandouw(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Janek Sendrowski | 2013-11-24 15:31:33 | /usr/bin/ld: cannot find [...] when compiling |
| Previous Message | Hengky Lie | 2013-11-24 14:57:19 | Query runs slow |