Re: BLOB / CLOB support in PostgreSQL

Поиск
Список
Период
Сортировка
От Vladimir Sitnikov
Тема Re: BLOB / CLOB support in PostgreSQL
Дата
Msg-id CAB=Je-GFPY1+Az5TgMRsWacb_Fdpg+4FZ4ua9-2tfLU3xaRv0g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BLOB / CLOB support in PostgreSQL  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Planner making bad choice in alternative subplan decision
Следующее
От: Tom Lane
Дата:
Сообщение: Why does PostgresNode.pm set such a low value of max_wal_senders?