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

slow GIST index creation

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: slow GIST index creation
Date: 2004-02-14 03:39:01
Message-ID: 402D9855.2020605@trade-india.com (view raw or flat)
Thread:
Lists: pgsql-performance
Greetings!

Why does creation of gist indexes takes significantly more time
than normal btree index. Can any configuration changes lead to faster index
creation?


query:
CREATE INDEX co_name_index_idx ON profiles USING gist (co_name_index 
public.gist_txtidx_ops);


regds
mallah.

pgsql-performance by date

Next:From: Marinos J. YannikosDate: 2004-02-15 02:02:48
Subject: Re: optimization ideas for frequent, large(ish) updates
Previous:From: Vivek KheraDate: 2004-02-13 22:03:30
Subject: Re: Disappointing performance in db migrated from MS SQL Server

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