Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E43BF2E003D for ; Fri, 6 Jun 2008 11:16:53 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59046-05 for ; Fri, 6 Jun 2008 11:16:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hook.sigaev.ru (hook.sigaev.ru [212.192.243.50]) by developer.postgresql.org (Postfix) with ESMTP id 1C59D2E003A for ; Fri, 6 Jun 2008 11:16:46 -0300 (ADT) Received: by hook.sigaev.ru (Postfix, from userid 1003) id EACE7398E2; Fri, 6 Jun 2008 18:16:41 +0400 (MSD) Received: from xor.sai.msu.ru (xor.sai.msu.ru [212.192.243.97]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by hook.sigaev.ru (Postfix) with ESMTP id DB56F398E0; Fri, 6 Jun 2008 18:16:38 +0400 (MSD) Message-ID: <484946C6.1080807@sigaev.ru> Date: Fri, 06 Jun 2008 18:16:38 +0400 From: Teodor Sigaev User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.13) Gecko/20080401 SeaMonkey/1.1.9 MIME-Version: 1.0 To: Heikki Linnakangas CC: Patches Subject: Re: GIN improvements References: <483FD205.4090904@sigaev.ru> <4849418C.6080909@sigaev.ru> <4849436F.30703@enterprisedb.com> In-Reply-To: <4849436F.30703@enterprisedb.com> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/43 X-Sequence-Number: 6529 > 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 I'm not sure that is acceptable because flushing pending list may take several seconds in unpredictable moment. > the buffer. To keep that overhead out of the main codepath, we could > make autovacuum to flush the buffers periodically. Do you mean that GIN sends a "smoke signal" to the autovacuum launcher process to ask about vacuum? -- Teodor Sigaev E-mail: teodor@sigaev.ru WWW: http://www.sigaev.ru/