Postgres Pro
Downloads
Home   >   mailing lists

Re: gin index creation performance problems - Mailing list pgsql-general

From Tom Lane
Subject Re: gin index creation performance problems
Date
Msg-id 3850.1225728285@sss.pgh.pa.us
Whole thread Raw
In response to gin index creation performance problems  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: gin index creation performance problems
List pgsql-general
Tree view 
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> maintenance_work_mem is still untouched. What would be a good value
> to start from?

GIN index build time is *very* sensitive to maintenance_work_mem.
Try cranking it up to a couple hundred megabytes and see if that
helps.

Also, if you're on 8.2, I think 8.3 might be faster.

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: gin index creation performance problems
Next
From: "Serge Fonville"
Date:
Subject: Specific user does not require password for postgres