Re: [SQL] EXTERNAL storage and substring on long strings - Mailing list pgsql-performance

From Jan Wieck
Subject Re: [SQL] EXTERNAL storage and substring on long strings
Date
Msg-id 3F3BDB2A.40506@Yahoo.com
Whole thread Raw
In response to Re: [SQL] EXTERNAL storage and substring on long strings  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:

> Jan Wieck <JanWieck@Yahoo.com> writes:
>> Doesn't look that unrealistic to me. A plain text based substring
>> function will reassemble the whole beast first before cutting out the
>> wanted part. His manually chunked version will read only those chunks
>> needed.
>
> So does substr(), if applied to EXTERNAL (non-compressed) toasted text.
> See John Gray's improvements a release or two back.

Duh ... of course, EXTERNAL is uncompressed ... where do I have my head?


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-performance by date:

Previous
From: Scott Cain
Date:
Subject: Re: [SQL] EXTERNAL storage and substring on long strings
Next
From: Tom Lane
Date:
Subject: Re: Vacuum performance question