BUG #8036: how to disable toasting

[zahid....@cloverinfotech.com]

The following bug has been logged on the website:

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

how to disable toasting in postgresql 9.0 please guide



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

[Bruce Momjian]

On Thu, Apr 4, 2013 at 11:12:54AM +0000, zahid....@cloverinfotech.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8036
> Logged by: anonymous
> Email address: zahid....@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 <br...@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.

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