Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1redcd-00CWVO-8m for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Feb 2024 16:14:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1redcb-00EuN0-Hc for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Feb 2024 16:14:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1redcb-00EuMs-8f for pgsql-hackers@lists.postgresql.org; Mon, 26 Feb 2024 16:14:29 +0000 Received: from m15.mail.163.com ([45.254.50.220]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1redcV-001EeO-AS for pgsql-hackers@lists.postgresql.org; Mon, 26 Feb 2024 16:14:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=From:Subject:Date:Message-ID:MIME-Version: Content-Type; bh=s1VrVunUe73wU6aE/9mz/sYxJi2rWngRQ+Y5/CbwyAU=; b=YVXIfX9BxWyOQ5bRNkUz7HF+saMAW5ldgvXOgez2wMbkERdFZVk6y6H8yq049M wwlCvwmIu/Nmpaf3S49gbRPUetOBWCeYm27sQMV9oTRkIYLD6gD1dhDr2lMe8zw6 LTTINuNrAthEyyzTiZvzCVxUZrAQ8NXd/c6OXx7EV04dg= Received: from 8235eee8a2a0 (unknown [140.205.118.69]) by gzga-smtp-mta-g0-5 (Coremail) with SMTP id _____wD3P5jWuNxlq0EJEQ--.36221S3; Tue, 27 Feb 2024 00:14:14 +0800 (CST) References: <87il4jrk1l.fsf@163.com> <87h6jxw41k.fsf@163.com> <87sf3andy2.fsf@163.com> <87wmskm9qu.fsf@163.com> <87v87kvboq.fsf@163.com> <71321d83-391b-473b-aaf6-618c7f682b96@postgrespro.ru> <87r0i7vos3.fsf@163.com> <874je3hcwn.fsf@163.com> <8734tmg88e.fsf@163.com> <7f4c8673-4c5d-4dbf-b8e5-0ec11cd2fba0@enterprisedb.com> <87h6i2djf9.fsf@163.com> <87jzms0xza.fsf@163.com> <87frxf1gld.fsf@163.com> User-agent: mu4e 1.10.7; emacs 29.1 From: Andy Fan To: Nikita Malakhov Cc: Tomas Vondra , Michael Zhilin , Peter Smith , vignesh C , Matthias van de Meent , pgsql-hackers@lists.postgresql.org Subject: Re: Shared detoast Datum proposal Date: Tue, 27 Feb 2024 00:08:33 +0800 In-reply-to: Message-ID: <871q8z19ux.fsf@163.com> MIME-Version: 1.0 Content-Type: text/plain X-CM-TRANSID: _____wD3P5jWuNxlq0EJEQ--.36221S3 X-Coremail-Antispam: 1Uf129KBjDUn29KB7ZKAUJUUUUU529EdanIXcx71UUUUU7v73 VFW2AGmfu7bjvjm3AaLaJ3UbIYCTnIWIevJa73UjIFyTuYvjxUU0edUUUUU X-Originating-IP: [140.205.118.69] X-CM-SenderInfo: x2klx3xlid0iqsrtqiywtou0bp/1tbiVBiQU2VOBoU1nQAAsP List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Nikita Malakhov writes: > Hi, > > Tomas, we already have a working jsonb partial detoast prototype, > and currently I'm porting it to the recent master. This is really awesome! Acutally when I talked to MySQL guys, they said MySQL already did this and I admit it can resolve some different issues than the current patch. Just I have many implemetion questions in my mind. > Andy, thank you! I'll check the last patch set out and reply in a day > or two. Thank you for your attention! -- Best Regards Andy Fan