Re: GiST index performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GiST index performance
Дата
Msg-id 26222.1239904772@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GiST index performance  (Matthew Wakeling <matthew@flymine.org>)
Ответы Re: GiST index performance  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance
Matthew Wakeling <matthew@flymine.org> writes:
> On Thu, 16 Apr 2009, Tom Lane wrote:
>> Also, what are the physical sizes of the two indexes?

>   location_object_start_gist | 193 MB
>   location_object_start      | 75 MB

>> I notice that the inner nestloop join gets slower too, when it's not
>> changed at all --- that suggests that the overall I/O load is a lot
>> worse, so maybe the reason the query is falling off a performance cliff
>> is that the GIST index fails to fit in cache.

> Memory in the machine is 16GB.

Hmm, and what is shared_buffers set to?  How big are the tables and
other indexes used in the query?  We still have to explain why the
inner nestloop got slower, and it's hard to see that unless something
stopped fitting in cache.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: GiST index performance
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: GiST index performance