Re: Speeding up Gist Index creations

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

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Martin Foster 2004-11-02 23:52:12 Restricting Postgres
Previous Message Neil Conway 2004-11-02 01:35:55 Re: Speeding up Gist Index creations