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?
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, April 18, 2007 2:09 PM
To: David Hinkle
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 Walter||Date: 2007-04-18 21:29:04|
|Subject: Re: Auto vacuum|
|Previous:||From: Tom Lane||Date: 2007-04-18 19:08:57|
|Subject: Re: Toast Problems |