pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Speeding up Gist Index creations
4+ messages / 3 participants
[nested] [flat]

* Speeding up Gist Index creations
@ 2004-10-31 21:03  mallah@trade-india.com
  0 siblings, 1 reply; 4+ messages in thread

From: mallah@trade-india.com @ 2004-10-31 21:03 UTC (permalink / raw)
  To: pgsql-performance



Hi ,

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 )

Regds
Mallah.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Speeding up Gist Index creations
@ 2004-11-01 00:01  Josh Berkus <josh@agliodbs.com>
  parent: mallah@trade-india.com
  0 siblings, 1 reply; 4+ messages in thread

From: Josh Berkus @ 2004-11-01 00:01 UTC (permalink / raw)
  To: pgsql-performance; +Cc: mallah@trade-india.com

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Speeding up Gist Index creations
@ 2004-11-02 01:35  Neil Conway <neilc@samurai.com>
  parent: Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Neil Conway @ 2004-11-02 01:35 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance; mallah@trade-india.com

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Speeding up Gist Index creations
@ 2004-11-02 05:58  Josh Berkus <josh@agliodbs.com>
  parent: Neil Conway <neilc@samurai.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Josh Berkus @ 2004-11-02 05:58 UTC (permalink / raw)
  To: pgsql-performance; +Cc: Neil Conway <neilc@samurai.com>; mallah@trade-india.com

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-11-02 05:58 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-31 21:03 Speeding up Gist Index creations mallah@trade-india.com
2004-11-01 00:01 ` Josh Berkus <josh@agliodbs.com>
2004-11-02 01:35   ` Neil Conway <neilc@samurai.com>
2004-11-02 05:58     ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox