Re: Speeding up Gist Index creations

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Speeding up Gist Index creations
Дата
Msg-id 1099359354.17405.150.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Speeding up Gist Index creations  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Speeding up Gist Index creations  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On Mon, 2004-11-01 at 11:01, Josh Berkus wrote:
> > Gist indexes take a long time to create as compared
> > to normal indexes is there any way to speed them up ?
> >
> > (for example by modifying sort_mem or something temporarily )
>
> More sort_mem will indeed help.

How so? sort_mem improves index creation for B+-tree because we
implement bulk loading; there is no implementation of bulk loading for
GiST, so I don't see how sort_mem will help.

-Neil



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Performance difference when using views
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Speeding up Gist Index creations