BUG #8036: how to disable toasting

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. +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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.quadri@cloverinfotech.com" <zahid.quadri@cloverinfotech.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs