Re: Regarding postgreSQL performance on DRAM

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Regarding postgreSQL performance on DRAM
Date: 2019-02-20 21:50:05
Message-ID: 1ee47afb-7867-adc6-0df2-c7b1f04f1576@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rohan Kadekodi 2019-02-20 21:50:51 Re: Regarding postgreSQL performance on DRAM
Previous Message Tom Lane 2019-02-20 21:04:23 Re: Regarding postgreSQL performance on DRAM