[HACKERS] ginfastupdate.. slow

2011-09-15 Thread Jesper Krogh
Hi List. This is just an observation I'll try to reproduce it in a test set later. I've been trying to performancetune a database system which does a lot of updates on GIN indexes. I currently have 24 workers running executing quite cpu-intensive stored procedures that helps generate the body

Re: [HACKERS] ginfastupdate.. slow

2011-09-15 Thread Oleg Bartunov
Jesper, are you sure you have autovacuum configured properly, so posting lists don't grow too much. It's true, that concurrency of posting lists isn't good, since they all appended. Oleg On Thu, 15 Sep 2011, Jesper Krogh wrote: Hi List. This is just an observation I'll try to reproduce it in