Re: BUG #8036: how to disable toasting
| От | Kevin Grittner |
|---|---|
| Тема | Re: BUG #8036: how to disable toasting |
| Дата | |
| Msg-id | 1365087301.25034.YahooMailNeo@web162906.mail.bf1.yahoo.com обсуждение исходный текст |
| Ответ на | BUG #8036: how to disable toasting (zahid.quadri@cloverinfotech.com) |
| Список | pgsql-bugs |
This is not a bug report; please use the pgsql-general list for=0Aquestions= like this, or for any follow-up on this question.=0A=0A"zahid.quadri@clove= rinfotech.com" <zahid.quadri@cloverinfotech.com> wrote:=0A=0A> PostgreSQL v= ersion: 9.0.5=0A=0AYou need to update to 9.0.13 as soon as possible.=0A=0Ah= ttp://www.postgresql.org/support/versioning/=0A=0Ahttp://www.postgresql.org= /support/security/faq/2013-04-04/=0A=0A> how to disable toasting in postgre= sql 9.0 please guide=0A=0AUse a statement like this for each column which y= ou want to keep in=0Athe main record (where the row still fits on the page)= :=0A=0A=A0 ALTER TABLE tablename ALTER COLUMN colname SET STORAGE MAIN;=0A= =0Ahttp://www.postgresql.org/docs/9.0/interactive/sql-altertable.html=0A=0A= http://www.postgresql.org/docs/9.0/interactive/storage-toast.html=0A=0A--= =0AKevin Grittner=0AEnterpriseDB: http://www.enterprisedb.com=0AThe Enterpr= ise PostgreSQL Company
В списке pgsql-bugs по дате отправления: