Re: [HACKERS] bytea_output output of base64

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: [HACKERS] bytea_output output of base64
Дата
Msg-id alpine.DEB.2.20.1702240906540.21598@lancre
обсуждение исходный текст
Ответ на Re: [HACKERS] bytea_output output of base64  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
> It undoubtedly would make pg_dump smaller, though I'm not sure how much 
> that's worth since if you care at all about that you'll gzip it.
>
> But, the other thing it might do is speed up COPY, especially on input. Some 
> performance tests of that might be interesting.

For what it is worth:

Ascii85 (aka Base85) is used in PDF by Adobe, with a prefix "<~" and a 
suffix "~>". It codes 4 bytes as 5 ascii characters, i.e. a 25% loss. 
There is also Z85 which avoids some special characters: backslash, single 
quote, double quote.

-- 
Fabien.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [HACKERS] UPDATE of partition key
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] UPDATE of partition key