Skip site navigation (1) Skip section navigation (2)

Re: Toast Problems

From: "David Hinkle" <hinkle(at)cipafilter(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Toast Problems
Date: 2007-04-18 19:35:26
Message-ID: 41CAB934FDE0DA4392781E79BDF1894710A07C@cipapdc.cipafilter.com (view raw or flat)
Thread:
Lists: pgsql-admin
I have Postgres on almost 400 boxes, some of which push over 2 million
transactions a day.  It's really been a wonderful product for us.

All of them use the same version of postgress (8.0.3), embedded onto a
64 meg flash chip.   So, doing a upgrade is a very big deal.   

Does anybody know if 8.0.3 had a problem with using compression on TOAST
fields?  Or where I could find changelogs to look through?


-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Wednesday, April 18, 2007 2:09 PM
To: David Hinkle
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Toast Problems 

"David Hinkle" <hinkle(at)cipafilter(dot)com> writes:
> Is there any way I can tell for sure if the messages from this column
> are being stored compressed?

Not in 8.0, but in more recent versions pg_column_size() would help.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Carol WalterDate: 2007-04-18 21:29:04
Subject: Re: Auto vacuum
Previous:From: Tom LaneDate: 2007-04-18 19:08:57
Subject: Re: Toast Problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group