Re: how to completely disable toasted table in postgresql and best practices to follow

Поиск
Список
Период
Сортировка
От AI Rumman
Тема Re: how to completely disable toasted table in postgresql and best practices to follow
Дата
Msg-id CAGoODpfw7BeN6POhBPnEhJtmO5LDP5euXqzF1GX-g5nj8WqFmA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to completely disable toasted table in postgresql and best practices to follow  (Szymon Guz <mabewlun@gmail.com>)
Список pgsql-general
Дерево обсуждения
According to doc, YES.

MAIN allows compression but not out-of-line storage. (Actually, out-of-line storage will still be performed for such columns, but only as a last resort when there is no other way to make the row small enough to fit on a page.)


On Fri, Apr 5, 2013 at 9:53 AM, Szymon Guz <mabewlun@gmail.com> wrote:

On 5 April 2013 15:49, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-04-05 18:32:47 +0530, Zahid Quadri wrote:
> Dear admin,
>
> please help me i want to completely disable Toasted tables in postgresql as per your suggestion i have used 9.0.13 but still toasted tables are getting created.
>
> also i want to know best practices and methods to clear such issues.

Why do you want to do that?

It is not possible to completely disable the usage of toast tables, but
maybe explaining the real reason of you wanting that helps us to give
you another solution.



Even if I set storage to plain for all the columns? Will then toast be used for something else?

regards
Szymon 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Is 'Peer authentication' supported on HPUX ?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: how to completely disable toasted table in postgresql and best practices to follow