Re: Need to increase performance of a query

От: Jochen Erwied
Тема: Re: Need to increase performance of a query
Дата: ,
Msg-id: 10510424234.20100610213924@erwied.eu
(см: обсуждение, исходный текст)
Ответ на: Re: Need to increase performance of a query  (Anne Rosset)
Ответы: Re: Need to increase performance of a query  (Anne Rosset)
Список: pgsql-performance

Скрыть дерево обсуждения

Need to increase performance of a query  (Anne Rosset, )
 Re: Need to increase performance of a query  (Jesper Krogh, )
  Re: Need to increase performance of a query  (Anne Rosset, )
   Re: Need to increase performance of a query  (Jochen Erwied, )
 Re: Need to increase performance of a query  (hubert depesz lubaczewski, )
 Re: Need to increase performance of a query  (Anne Rosset, )
  Re: Need to increase performance of a query  (Kenneth Marshall, )
   Re: Need to increase performance of a query  (Anne Rosset, )
  Re: Need to increase performance of a query  (Jochen Erwied, )
   Re: Need to increase performance of a query  (Anne Rosset, )
  Re: Need to increase performance of a query  (Craig James, )
   Re: Need to increase performance of a query  (Anne Rosset, )
    Re: Need to increase performance of a query  (Joe Conway, )
     Re: Need to increase performance of a query  (Joe Conway, )
      Re: Need to increase performance of a query  (Anne Rosset, )
       Re: Need to increase performance of a query  (Joe Conway, )
        Re: Need to increase performance of a query  (Anne Rosset, )
   Re: Need to increase performance of a query  (Heikki Linnakangas, )
    Re: Need to increase performance of a query  (Anne Rosset, )
     Re: Need to increase performance of a query  (Heikki Linnakangas, )

Thursday, June 10, 2010, 9:34:07 PM you wrote:

> Time: 1.516 ms

> Time: 13.177 ms

I'd suppose the first query to scan a lot less rows than the second one.
Could you supply an explained plan for the fast query?

--
Jochen Erwied     |   home:      +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work:   +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile:        +49-173-5404164



В списке pgsql-performance по дате сообщения:

От: Robert Haas
Дата:
Сообщение: Re: slow query performance
От: Andy Colson
Дата:
Сообщение: Re: Analysis Function