Re: Speeding up Gist Index creations - Mailing list pgsql-performance

From Neil Conway
Subject Re: Speeding up Gist Index creations
Date
Msg-id 1099359354.17405.150.camel@localhost.localdomain
Whole thread Raw
In response to Re: Speeding up Gist Index creations  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Speeding up Gist Index creations  (Josh Berkus <josh@agliodbs.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Performance difference when using views
Next
From: Josh Berkus
Date:
Subject: Re: Speeding up Gist Index creations