Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bWgFJ-00011M-A4 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Aug 2016 08:49:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bWgFI-0005oG-TB for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Aug 2016 08:49:16 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bWgDv-000448-Ni for pgsql-hackers@postgresql.org; Mon, 08 Aug 2016 08:47:51 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bWgDe-00034b-Tr for pgsql-hackers@postgresql.org; Mon, 08 Aug 2016 08:47:50 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 84B0F21C2AD6; Mon, 8 Aug 2016 11:47:32 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id oPOT99--iElA; Mon, 8 Aug 2016 11:47:32 +0300 (MSK) Received: from [192.168.27.79] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 4AE2221C2AD4; Mon, 8 Aug 2016 11:47:32 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1470646052; bh=K9qLEVUaFfBVLvrYkF828mn90Xfz1tT6hilWF8pppWg=; h=Subject:To:References:Cc:From:Date:In-Reply-To; b=gp2kRUWUwGb/fCppvd+nsKJT74Uz++SfCL7zbs9vspNNrf5ASsKuFla+BbF1h+Y2h zjxpJExrOoc6MPxo8EUNNnOZZqcv/fPNFjzNdYrQmORtEoVy3OERSYjdqlhuTDPVqX a/NkfB/f5qlpkNutL1TsusihNW92AkXepgPgeZxc= Subject: Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables) To: Robert Haas , Aleksander Alekseev References: <20160729141552.4062e19b@fujitsu> <39b0f423-a4df-3564-3b4a-b1de6f9eea80@2ndquadrant.com> <1184.1469890030@sss.pgh.pa.us> <5cdc3fde-d6a5-f0d2-b930-485bdcaecde5@2ndquadrant.com> <20160801124531.66cde374@fujitsu> <26c3bc60-6613-e7ab-517a-53136f01fb6c@2ndquadrant.com> <13191.1470072250@sss.pgh.pa.us> <20160804151451.6fb87507@fujitsu> Cc: Tom Lane , Tomas Vondra , Pavel Stehule , PostgreSQL Hackers , David Steele From: Anastasia Lubennikova Message-ID: <44fd10a5-2d16-86a4-5192-b85a6a16790c@postgrespro.ru> Date: Mon, 8 Aug 2016 11:47:32 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.5 (--) 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 05.08.2016 19:41, Robert Haas: > > 2. This inserts additional code in a bunch of really low-level places > like heap_hot_search_buffer, heap_update, heap_delete, etc. I think > what you've basically done here is create a new, in-memory heap AM and > then, because we don't have an API for adding new storage managers, > you've bolted it onto the existing heapam layer. That's certainly a > reasonable approach for creating a PoC, but I think we actually need a > real API here. Otherwise, when the next person comes along and wants > to add a third heap implementation, they've got to modify all of these > same places again. I don't think this code is reasonably maintainable > in this form. As I can see, you recommend to clean up the API of storage management code. I strongly agree that it's high time to do it. So, I started the discussion about refactoring and improving API of heapam and heap relations. You can find it on commitfest: https://commitfest.postgresql.org/10/700/ I'll be glad to see your thoughts on the thread. -- Anastasia Lubennikova Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers