Skip site navigation (1) Skip section navigation (2)

Re: GIN improvements

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Teodor Sigaev" <teodor(at)sigaev(dot)ru>
Cc: "Patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: GIN improvements
Date: 2008-06-06 14:02:23
Message-ID: 4849436F.30703@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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

In response to

Responses

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2008-06-06 14:16:38
Subject: Re: GIN improvements
Previous:From: Teodor SigaevDate: 2008-06-06 13:54:20
Subject: Re: GIN improvements

pgsql-patches by date

Next:From: Teodor SigaevDate: 2008-06-06 14:16:38
Subject: Re: GIN improvements
Previous:From: Teodor SigaevDate: 2008-06-06 13:54:20
Subject: Re: GIN improvements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group