Re: GIN improvements

Teodor Sigaev wrote:
> 
>> 2) fast insert into GIN
> New version:
> http://www.sigaev.ru/misc/fast_insert_gin-0.6.gz
> 
> Changes:
> - added option FASTUPDATE=(1|t|true|on|enable|0|f|false|disable) for
>   CREATE/ALTER command for GIN indexes

I think we should try to make it automatic. I'm not sure how.

How about having a constant sized "fastupdate" buffer, of say 100 rows 
or a fixed number of pages, and when that becomes full, the next 
inserter will have to pay the price of updating the index and flushing 
the buffer. To keep that overhead out of the main codepath, we could 
make autovacuum to flush the buffers periodically.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com