Re: Runtime dependency from size of a bytea field

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Runtime dependency from size of a bytea field
Дата
Msg-id AANLkTi=8Qji6Z+6AjbYATOCwLo32nF_CRppf5+pd7u36@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Runtime dependency from size of a bytea field  ("Sander, Ingo (NSN - DE/Munich)" <ingo.sander@nsn.com>)
Ответы Re: Runtime dependency from size of a bytea field  ("Sander, Ingo (NSN - DE/Munich)" <ingo.sander@nsn.com>)
Список pgsql-performance
On Wed, Oct 6, 2010 at 1:39 AM, Sander, Ingo (NSN - DE/Munich)
<ingo.sander@nsn.com> wrote:
> Changing of the storage method ( alter table bytea_demo Alter part1 Set
> storage EXTERNAL)
> or the increasing of the BLOCK_SIZE (new compilation of the code with
> --with-blocksize=32) change the behaviour.

yeah -- however changing block size is major surgery and is going to
have other effects (some of them negative) besides raising toast
threshold.  I would start with disabling compression and see where you
stood on performance terms.

merlin

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

Предыдущее
От: "Sander, Ingo (NSN - DE/Munich)"
Дата:
Сообщение: Re: Runtime dependency from size of a bytea field
Следующее
От: "Sander, Ingo (NSN - DE/Munich)"
Дата:
Сообщение: Re: Runtime dependency from size of a bytea field