Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: Speeding up Gist Index creations
Date
Msg-id 200411012158.35549.josh@agliodbs.com
Whole thread Raw
In response to Re: Speeding up Gist Index creations  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
Tree view 
Neil,

> 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.

Ah, wasn't aware of that deficiency.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: Speeding up Gist Index creations
Next
From: Martin Foster
Date:
Subject: Restricting Postgres