Re: SUBSTRING performance for large BYTEA

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: SUBSTRING performance for large BYTEA
Дата
Msg-id 46C7260B.6060409@commandprompt.com
обсуждение исходный текст
Ответ на Re: SUBSTRING performance for large BYTEA  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SUBSTRING performance for large BYTEA
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>> Should we consider setting storage external by default for the type?
>
> No.  That would be counterproductive for the more typical case of bytea
> values in the range of some-small-number-of-kilobytes.  Or at least
> I think that's more typical than values that are so large you have to go
> out of your way to fetch them in chunks.

The typical case that I run into with Bytea is storing enough
information to where this would be useful. Specifically items such as
pdf and .doc.

Sincerely,

Joshua D. Drake

>
>             regards, tom lane
>


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGxyYLATb/zqfZUUQRAq5gAJsGFIHglJGcGjqjNc92G6Wt2U+cwQCghGMV
181pA78JUFIfpepzXLY1eK0=
=GJGH
-----END PGP SIGNATURE-----

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

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: Blobs in Postgresql
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: SUBSTRING performance for large BYTEA