Re: Possible to improve query plan?

От: Kevin Grittner
Тема: Re: Possible to improve query plan?
Дата: ,
Msg-id: 4D3D64A60200002500039B1E@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Possible to improve query plan?  (Tom Lane)
Ответы: Re: Possible to improve query plan?  (Jeremy Palmer)
Список: pgsql-performance

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

Possible to improve query plan?  (Jeremy Palmer, )
   Re: Possible to improve query plan?  (Andy Colson, )
    Re: Possible to improve query plan?  (Jeremy Palmer, )
   Re: Possible to improve query plan?  ("Ing. Marcos Ortiz Valmaseda", )
    Re: Possible to improve query plan?  (Jeremy Palmer, )
   Re: Possible to improve query plan?  ("Kevin Grittner", )
    Re: Possible to improve query plan?  (Robert Haas, )
     Re: Possible to improve query plan?  ("Kevin Grittner", )
      Re: Possible to improve query plan?  (Tom Lane, )
       Re: Possible to improve query plan?  ("Kevin Grittner", )
        Re: Possible to improve query plan?  (Jeremy Palmer, )
         Re: Possible to improve query plan?  ("Kevin Grittner", )
          Re: Possible to improve query plan?  (Cédric Villemain, )
         Re: Possible to improve query plan?  ("Kevin Grittner", )
          Re: Possible to improve query plan?  (Jeremy Palmer, )
     Re: Possible to improve query plan?  (Tom Lane, )

Tom Lane <> wrote:

> Um, that looks like 90 usec per row, not msec.

Oh, right.  Well, having to do a random heap access for 1% of the
rows would pretty much explain the run time, then.

-Kevin


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

От: Jeremy Palmer
Дата:
Сообщение: Re: Possible to improve query plan?
От: "Kevin Grittner"
Дата:
Сообщение: Re: Possible to improve query plan?