Re: [PERFORM] Gin index insert performance issue

2012-03-14 Thread Rural Hunter
I disabled fastupdate on the gin index. looks it solved my problem, at least for now. Thanks a lot for your help Jesper! -- Thanks for the reply. Your index is much larger than mine..so I see some light. :) ?? 2012/3/13 14:29, Jesper Krogh : Our solution is to

Re: [PERFORM] Gin index insert performance issue

2012-03-13 Thread Rural Hunter
Thanks for the reply. Your index is much larger than mine..so I see some light. :) ?? 2012/3/13 14:29, Jesper Krogh : Our solution is to turn "fastupdate" off for our gin-indices. http://www.postgresql.org/docs/9.0/static/sql-createindex.html Can also be set with ALTER TABLE ALTER INDEX I

Re: [PERFORM] Gin index insert performance issue

2012-03-12 Thread Jesper Krogh
On 13/03/12 06:43, Rural Hunter wrote: I tried to increase work_mem but the inserts hang more time each time with less frequency. So it makes almost no difference for the total hanging time. Frequent vacuum is not a choice since the hang happens very 3-5 mins. is there any improvement I can m

[PERFORM] Gin index insert performance issue

2012-03-12 Thread Rural Hunter
I'm using gin index for my full text search engine in production. These days the gin index size grows to 20-30G and the system started to suffer with periodical insert hanging. This is same as described in the 2 posts: http://postgresql.1045698.n5.nabble.com/Random-penalties-on-GIN-index-updates