Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gwZkt-0004xa-5r for pgsql-admin@arkaria.postgresql.org; Wed, 20 Feb 2019 21:50:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gwZkr-0007MT-Oz for pgsql-admin@arkaria.postgresql.org; Wed, 20 Feb 2019 21:50:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gwZkr-00075U-Cg for pgsql-admin@lists.postgresql.org; Wed, 20 Feb 2019 21:50:13 +0000 Received: from mail-out.m-online.net ([212.18.0.9]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gwZko-00018f-Im for pgsql-admin@lists.postgresql.org; Wed, 20 Feb 2019 21:50:12 +0000 Received: from frontend01.mail.m-online.net (unknown [192.168.8.182]) by mail-out.m-online.net (Postfix) with ESMTP id 444WVR5gJDz1rfNB for ; Wed, 20 Feb 2019 22:50:07 +0100 (CET) Received: from localhost (dynscan1.mnet-online.de [192.168.6.70]) by mail.m-online.net (Postfix) with ESMTP id 444WVR2kFDz1qr5w for ; Wed, 20 Feb 2019 22:50:07 +0100 (CET) X-Virus-Scanned: amavisd-new at mnet-online.de Received: from mail.mnet-online.de ([192.168.8.182]) by localhost (dynscan1.mail.m-online.net [192.168.6.70]) (amavisd-new, port 10024) with ESMTP id BcB0Dvn-8ZTq for ; Wed, 20 Feb 2019 22:50:06 +0100 (CET) Received: from [192.168.178.37] (ppp-93-104-69-206.dynamic.mnet-online.de [93.104.69.206]) by mail.mnet-online.de (Postfix) with ESMTP for ; Wed, 20 Feb 2019 22:50:06 +0100 (CET) Subject: Re: Regarding postgreSQL performance on DRAM To: pgsql-admin@lists.postgresql.org References: <87va1exlfo.fsf@jsievers.enova.com> <29251.1550696663@sss.pgh.pa.us> From: Thomas Kellerer Message-ID: <1ee47afb-7867-adc6-0df2-c7b1f04f1576@gmx.net> Date: Wed, 20 Feb 2019 22:50:05 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: <29251.1550696663@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tom Lane schrieb am 20.02.2019 um 22:04: >> Hmm. I though TOAST is only applied to single values, not the entire tuple (row)? >> As each column is substantially shorter than the TOAST threshold, I would not expect toasting to kick in here. > > Well, the entire tuple would be 25600 bytes plus some overhead, which > cannot fit on a Postgres page (8K, unless the OP changed compile options > without mentioning it). So something has to be done to make it fit, and > that something is going to be toasting any fields that can be toasted. Ah, obviously. Thanks