Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group