Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYgPF-00057Y-V3 for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Jan 2017 21:56:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cYgPF-0000ml-EK for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Jan 2017 21:56:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYgPE-0000l0-7P for pgsql-hackers@postgresql.org; Tue, 31 Jan 2017 21:56:04 +0000 Received: from [66.111.4.25] (helo=out1-smtp.messagingengine.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYgPB-0003aQ-MK for pgsql-hackers@postgresql.org; Tue, 31 Jan 2017 21:56:03 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 16F2823F18; Tue, 31 Jan 2017 16:55:40 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute5.internal (MEProxy); Tue, 31 Jan 2017 16:55:40 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=smtpout; bh=uIYiE7baRxG7fK vTW7H4ZD/sFqk=; b=TIxoFjAKfE5bc6C/9r+SneC1MGbpHmJZBRwE69hcLdAAXT OGR6W9d79Zlu0B5QQ4D+sbt9Nz7PiKfdnzCR51oOobTh6NZO+4zJ+3oF3NVS66T6 S2F7MdBcZPyRc8Tx2wczTGLSYFESkcBKf/vB6qaeSIIH2ZrL1568VArf1lzKc= X-ME-Sender: X-Sasl-enc: 2skKsITgwJ46Q6yES29aBbMVPyKZn0NYxWmfT7o66Vsb 1485899739 Received: from intern.anarazel.de (unknown [208.72.138.107]) by mail.messagingengine.com (Postfix) with ESMTPA id CA5C37E446; Tue, 31 Jan 2017 16:55:39 -0500 (EST) Date: Tue, 31 Jan 2017 13:55:38 -0800 From: Andres Freund To: Alvaro Herrera Cc: Pavan Deolasee , Jaime Casanova , Haribabu Kommi , Tomas Vondra , pgsql-hackers Subject: Re: Patch: Write Amplification Reduction Method (WARM) Message-ID: <20170131215538.5c65rexachourokl@alap3.anarazel.de> References: <20170131171001.wg7bc4pimfu6in6t@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20170131171001.wg7bc4pimfu6in6t@alvherre.pgsql> X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.25 (deferred) X-Pg-Spam-Score: -1.8 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2017-01-31 14:10:01 -0300, Alvaro Herrera wrote: > Pavan Deolasee wrote: > > > Two new APIs added. > > > > - CatalogInsertHeapAndIndex which does a simple_heap_insert followed by > > catalog updates > > - CatalogUpdateHeapAndIndex which does a simple_heap_update followed by > > catalog updates > > > > There are only a handful callers remain for simple_heap_insert/update after > > this patch. They are typically working with already opened indexes and > > hence I left them unchanged. > > Hmm, I was thinking we would get rid of CatalogUpdateIndexes altogether. > Two of the callers are in the new routines (which I propose to rename to > CatalogTupleInsert and CatalogTupleUpdate); the only remaining one is in > InsertPgAttributeTuple. I propose that we inline the three lines into > all those places and just remove CatalogUpdateIndexes. Half the out-of- > core places that are using this function will be broken as soon as WARM > lands anyway. I see no reason to keep it. (I have already modified the > patch this way -- no need to resend). > > Unless there are objections I will push this later this afternoon. Hm, sorry for missing this earlier. I think CatalogUpdateIndexes() is fairly widely used in extensions - it seems like a pretty harsh change to not leave some backward compatibility layer in place. Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers