Thread: BUG #8036: how to disable toasting
The following bug has been logged on the website: Bug reference: 8036 Logged by: anonymous Email address: zahid.quadri@cloverinfotech.com PostgreSQL version: 9.0.5 Operating system: windows Description: = how to disable toasting in postgresql 9.0 please guide
On Thu, Apr 4, 2013 at 11:12:54AM +0000, zahid.quadri@cloverinfotech.com wrote: > The following bug has been logged on the website: > > Bug reference: 8036 > Logged by: anonymous > Email address: zahid.quadri@cloverinfotech.com > PostgreSQL version: 9.0.5 > Operating system: windows > Description: > > how to disable toasting in postgresql 9.0 please guide See ALTER TABLE SET STORAGE. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
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