Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 870AE64FED7 for ; Tue, 22 Jul 2008 13:37:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44706-01-6 for ; Tue, 22 Jul 2008 13:36:51 -0300 (ADT) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by postgresql.org (Postfix) with ESMTP id 14531650388 for ; Tue, 22 Jul 2008 13:20:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mx3.hub.org (Postfix) with ESMTP id 5137437B736 for ; Tue, 22 Jul 2008 13:04:44 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m6MG3PF7029438; Tue, 22 Jul 2008 12:03:26 -0400 (EDT) To: Teodor Sigaev cc: Oleg Bartunov , Pgsql Hackers Subject: Re: [PATCHES] GIN improvements In-reply-to: <487A6E0C.3090600@sigaev.ru> References: <483FD205.4090904@sigaev.ru> <486BC501.6060605@sigaev.ru> <27880.1215810535@sss.pgh.pa.us> <487A6E0C.3090600@sigaev.ru> Comments: In-reply-to Teodor Sigaev message dated "Mon, 14 Jul 2008 01:05:16 +0400" Date: Tue, 22 Jul 2008 12:03:25 -0400 Message-ID: <29437.1216742605@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/995 X-Sequence-Number: 121255 Teodor Sigaev writes: > Updated: http://www.sigaev.ru/misc/fast_insert_gin-0.9.gz > I still havn't clearness of acceptability for suggested aminsertcleanup calling. I started to look at this. I don't understand why VACUUM does an insert cleanup before starting to vacuum, but VACUUM FULL doesn't? I don't particularly like the idea of adding aminsertcleanup calls immediately before other AM operations such as ambulkdelete. It seems to me that those operations ought to include the cleanup subroutine themselves, if they need it; they shouldn't depend on callers to get this right. Offhand it looks to me like the only new index AM call needed is the one at vacuum startup, which tempts me to propose that the new AM entry point should be called "amvacuumstartup", instead of wiring in the assumption that what it's for is specifically cleanup of insertions. Comments? I can make the change if you think it's okay --- I'm busy cleaning up docs and comments at the moment. regards, tom lane