Re: BLOB / CLOB support in PostgreSQL - Mailing list pgsql-hackers

From Vladimir Sitnikov
Subject Re: BLOB / CLOB support in PostgreSQL
Date
Msg-id CAB=Je-GFPY1+Az5TgMRsWacb_Fdpg+4FZ4ua9-2tfLU3xaRv0g@mail.gmail.com
Whole thread Raw
In response to Re: BLOB / CLOB support in PostgreSQL  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
List pgsql-hackers
Andrew>It needs to contain a substantial implementation plan

Here's an implementation plan, again, quoted from the very same mail:

Vladimir>Of course both variations above fail to support streaming
Vladimir> (as in "need to process all the contents in order to get the last character"), so it might be better to use
Vladimir>"prefix that specifies encoding + 'index block' (that specifies offsets for each 1M characters) + encoded string".

It does describe the data structure.

Andrew>what APIS

I believe it does not matter much.
However, it might be similar to the existing LO APIs, except the indices are in characters rather than bytes.

Andrew>protocol changes

None.

Andrew>and so on

Well, it looks like I had everything you mentioned in the very first email.

Vladimir

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Planner making bad choice in alternative subplan decision
Next
From: Tom Lane
Date:
Subject: Why does PostgresNode.pm set such a low value of max_wal_senders?