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

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Zahid Quadri <zahid(dot)quadri(at)cloverinfotech(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to completely disable toasted table in postgresql and best practices to follow
Date: 2013-04-05 13:53:40
Message-ID: CAFjNrYtLhD+ExJjBHBpg_jt8BUNhrBcn2MnOZHRAW2=hvxwL5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-04-05 13:55:37 Re: Is 'Peer authentication' supported on HPUX ?
Previous Message Andres Freund 2013-04-05 13:49:48 Re: how to completely disable toasted table in postgresql and best practices to follow