Re: Speeding up Gist Index creations

From: Neil Conway <neilc(at)samurai(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, mallah(at)trade-india(dot)com
Subject: Re: Speeding up Gist Index creations
Date: 2004-11-02 01:35:55
Message-ID: 1099359354.17405.150.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-11-02 05:58:35 Re: Speeding up Gist Index creations
Previous Message Simon Riggs 2004-11-01 22:28:50 Re: Performance difference when using views