Re: Regarding postgreSQL performance on DRAM - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: Regarding postgreSQL performance on DRAM
Date
Msg-id 1ee47afb-7867-adc6-0df2-c7b1f04f1576@gmx.net
Whole thread Raw
In response to Re: Regarding postgreSQL performance on DRAM  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regarding postgreSQL performance on DRAM
Next
From: Rohan Kadekodi
Date:
Subject: Re: Regarding postgreSQL performance on DRAM