Re: Speeding up Gist Index creations

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: mallah(at)trade-india(dot)com
Subject: Re: Speeding up Gist Index creations
Date: 2004-11-01 00:01:15
Message-ID: 200410311601.15408.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mallah,

> 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. So will more RAM and a faster CPU.

Our GIST-index-creation process is probably not optimized; this has been
marked as "needs work" in the code for several versions. If you know anyone
who can help Oleg & Teodor out, be put them in touch ...

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gaetano Mendola 2004-11-01 01:11:45 Re: [PATCHES] [HACKERS] ARC Memory Usage analysis
Previous Message mallah 2004-10-31 21:03:10 Speeding up Gist Index creations