slow GIST index creation - Mailing list pgsql-performance

From Rajesh Kumar Mallah
Subject slow GIST index creation
Date
Msg-id 402D9855.2020605@trade-india.com
Whole thread Raw
List 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:

Previous
From: Vivek Khera
Date:
Subject: Re: Disappointing performance in db migrated from MS SQL Server
Next
From: "Marinos J. Yannikos"
Date:
Subject: Re: optimization ideas for frequent, large(ish) updates