Re: bytea vs. pg_dump

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: bytea vs. pg_dump
Дата
Msg-id 4A0174BC.3010106@dunslane.net
обсуждение исходный текст
Ответ на Re: bytea vs. pg_dump  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: bytea vs. pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Bernd Helmle wrote:
> --On Dienstag, Mai 05, 2009 16:57:50 -0400 Andrew Dunstan 
> <andrew@dunslane.net> wrote:
>
>> Hex will already provide some space savings over our current encoding
>> method for most byteas anyway. It's not like we'd be making things less
>> efficient space-wise. And in compressed archives the space difference is
>> likely to dissolve to not very much, I suspect.
>
> I'm dumb: I don't understand why a hex conversion would be 
> significantly faster than what we have now?
>

Quite apart from anything else you would not need the current loop over 
the bytea input to calculate the result length - in hex it would just be 
the input length * 2.

cheers

andrew


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

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: Values of fields in Rules
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: bytea vs. pg_dump