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@xxxxxxxxxxxxx] Sent: Wednesday, April 18, 2007 2:09 PM To: David Hinkle Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Toast Problems "David Hinkle" <hinkle@xxxxxxxxxxxxxx> 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
