Re: arrays, inline to pointer

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: arrays, inline to pointer
Date: 2016-05-03 08:36:05
Message-ID: 32d0f894-c110-4a7c-51d9-2485bf60f605@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/3/2016 1:21 AM, Marcus Engene wrote:
> For each array I've added, and populated, any dealings with the table
> has become way way slower. I can only assume this is because the array
> data is inline in the datablock on disk that stores the row.

any field on a table thats more than a few dozen bytes gets 'toasted'
and stored out of line in special 'toast' tables.

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Evgeny Morozov 2016-05-03 08:41:15 Re: Allow disabling folding of unquoted identifiers to lowercase
Previous Message Marcus Engene 2016-05-03 08:21:10 arrays, inline to pointer