Re: Multiple Indexing, performance impact

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Multiple Indexing, performance impact
Дата
Msg-id 5120.993235705@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Multiple Indexing, performance impact  (Daniel Åkerud <zilch@home.se>)
Список pgsql-general
=?iso-8859-1?Q?Daniel_=C5kerud?= <zilch@home.se> writes:
> Anyone know what causes the signifacant performance decrease after 7 indexe=
> s?

I'd bet that somewhere around there, you are starting to see thrashing
of the buffer pool due to needing to touch too many different pages to
insert each tuple.  What is your -B setting?  If you increase it,
does the performance improve?

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Rerefences to derived rows
Следующее
От: Daniel Åkerud
Дата:
Сообщение: TCP/IP Sockets, UNIX Sockets