Re: gin index creation performance problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: gin index creation performance problems
Date: 2008-11-03 16:04:45
Message-ID: 3850.1225728285@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Serge Fonville 2008-11-03 16:21:21 Specific user does not require password for postgres
Previous Message Oleg Bartunov 2008-11-03 16:03:18 Re: gin index creation performance problems