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

According to doc, YES.

http://www.postgresql.org/docs/9.2/static/storage-toast.html
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(at)gmail(dot)com> wrote:

>
> On 5 April 2013 15:49, Andres Freund <andres(at)2ndquadrant(dot)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
>
>