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