Re: BUG #8036: how to disable toasting

This is not a bug report; please use the pgsql-general list for
questions like this, or for any follow-up on this question.

"zahid(dot)quadri(at)cloverinfotech(dot)com" <zahid(dot)quadri(at)cloverinfotech(dot)com> wrote:

> PostgreSQL version: 9.0.5

You need to update to 9.0.13 as soon as possible.

http://www.postgresql.org/support/versioning/

http://www.postgresql.org/support/security/faq/2013-04-04/

> how to disable toasting in postgresql 9.0 please guide

Use a statement like this for each column which you want to keep in
the main record (where the row still fits on the page):

  ALTER TABLE tablename ALTER COLUMN colname SET STORAGE MAIN;

http://www.postgresql.org/docs/9.0/interactive/sql-altertable.html

http://www.postgresql.org/docs/9.0/interactive/storage-toast.html

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company