Re: Query runs slow
| От | Kevin Grittner |
|---|---|
| Тема | Re: Query runs slow |
| Дата | |
| Msg-id | 1385306469.35533.YahooMailNeo@web162901.mail.bf1.yahoo.com обсуждение исходный текст |
| Ответ на | Query runs slow (Hengky Lie <hengkyliwandouw@gmail.com>) |
| Ответы |
Re: Query runs slow
|
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: