Re: BUG #8036: how to disable toasting - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #8036: how to disable toasting
Date
Msg-id 1365087301.25034.YahooMailNeo@web162906.mail.bf1.yahoo.com
Whole thread Raw
In response to BUG #8036: how to disable toasting  (zahid.quadri@cloverinfotech.com)
List pgsql-bugs
This is not a bug report; please use the pgsql-general list for=0Aquestions=
 like this, or for any follow-up on this question.=0A=0A"zahid.quadri@clove=
rinfotech.com" <zahid.quadri@cloverinfotech.com> wrote:=0A=0A> PostgreSQL v=
ersion: 9.0.5=0A=0AYou need to update to 9.0.13 as soon as possible.=0A=0Ah=
ttp://www.postgresql.org/support/versioning/=0A=0Ahttp://www.postgresql.org=
/support/security/faq/2013-04-04/=0A=0A> how to disable toasting in postgre=
sql 9.0 please guide=0A=0AUse a statement like this for each column which y=
ou want to keep in=0Athe main record (where the row still fits on the page)=
:=0A=0A=A0 ALTER TABLE tablename ALTER COLUMN colname SET STORAGE MAIN;=0A=
=0Ahttp://www.postgresql.org/docs/9.0/interactive/sql-altertable.html=0A=0A=
http://www.postgresql.org/docs/9.0/interactive/storage-toast.html=0A=0A--=
=0AKevin Grittner=0AEnterpriseDB: http://www.enterprisedb.com=0AThe Enterpr=
ise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #8036: how to disable toasting
Next
From: Heikki Linnakangas
Date:
Subject: pg_stat_statements doesn't work with --disable-spinlocks