Re: GiST index performance

От: Matthew Wakeling
Тема: Re: GiST index performance
Дата: ,
Msg-id: alpine.DEB.2.00.0904161822060.22330@aragorn.flymine.org
(см: обсуждение, исходный текст)
Ответ на: GiST index performance  (Matthew Wakeling)
Список: pgsql-performance

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

GiST index performance  (Matthew Wakeling, )
 Re: GiST index performance  ("Kevin Grittner", )
  Re: GiST index performance  (Matthew Wakeling, )
  Re: GiST index performance  (Tom Lane, )
   Re: GiST index performance  (Matthew Wakeling, )
    Re: GiST index performance  (Tom Lane, )
     Re: GiST index performance  (Matthew Wakeling, )
   Re: GiST index performance  (Matthew Wakeling, )
    Re: GiST index performance  (Matthew Wakeling, )
     Re: GiST index performance  (Tom Lane, )
 Re: GiST index performance  (Matthew Wakeling, )
 Re: GiST index performance  (dforum, )
  Re: GiST index performance  (Tom Lane, )
  Re: GiST index performance  (Craig Ringer, )
 Re: GiST index performance  (Matthew Wakeling, )
  Re: GiST index performance  (Matthew Wakeling, )
   Re: GiST index performance  (Matthew Wakeling, )
    Re: GiST index performance  (Tom Lane, )
     Re: GiST index performance  (Oleg Bartunov, )
 Re: GiST index performance  (Matthew Wakeling, )
  Re: GiST index performance  (Bruce Momjian, )
   Re: GiST index performance  (Robert Haas, )
    Re: GiST index performance  (Bruce Momjian, )

On Thu, 16 Apr 2009, dforum wrote:
> there is other performance problem on this request.
>
> If you analyse query plan, you see that most of the time are lost during
> sequencial scan, and you have 2 seq scan.

Nonsense. Sequential scans account for all of one or two seconds of
processing in these queries, which are 14 seconds and 38 minutes
respectively.

Matthew

--
 Doctor:  Are you okay? You appear to be injured.
 Neelix:  Aaaaaaah!
 Doctor:  It's okay, it looks superficial.
 Neelix:  Am I going to die?
 Doctor:  Not unless you are allergic to tomatoes. This appears to be a sauce
          some kind.


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

От: Tom Lane
Дата:
Сообщение: Re: No hash join across partitioned tables?
От: Kris Jurka
Дата:
Сообщение: Re: No hash join across partitioned tables?