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 <mabew...@gmail.com> wrote: > > On 5 April 2013 15:49, Andres Freund <and...@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 > >
