BUG #8036: how to disable toasting

[z***@cloverinfotech.com]

The following bug has been logged on the website:

Bug reference: 8036
Logged by: anonymous
Email address: ***@cloverinfotech.com
PostgreSQL version: 9.0.5
Operating system: windows
Description:

how to disable toasting in postgresql 9.0 please guide

[Bruce Momjian]

Post by z***@cloverinfotech.com
Bug reference: 8036
Logged by: anonymous
PostgreSQL version: 9.0.5
Operating system: windows
how to disable toasting in postgresql 9.0 please guide

See ALTER TABLE SET STORAGE.
--
Bruce Momjian <***@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

[Kevin Grittner]

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

Post by z***@cloverinfotech.com
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/

Post by z***@cloverinfotech.com
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