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
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
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
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
