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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.

Browse pgsql-performance by date

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