Re: more about pg_toast growth

On Fri, 2002-03-15 at 06:47, Jan Wieck wrote:
> Jeffrey W. Baker wrote:
> > On Wed, 2002-03-13 at 12:16, Jan Wieck wrote:
> > >
> > > Are you sure you're B64-encoding the gzipped text?
> >
> > I am positive:
> >
> > rupert=# select substr(body, 0, 200) from resp_body where resp = (select
> > max(resp) from resp_body);
> >
> > eJztfXt34riy799hrf4OGuZMJ1k3BL949SScRQhJmCbAAbp7z75zV5bAAjxtbI5tkjB75rvfkiwb
> > GxxDHt0dgvtBjC2VpFLVr6qkknMydiZ6+WRMsFo+6dV7jVqZnOE5ami2oxkjG31ALWdMLLgxIIZN
> > UFvHDrFPsm7Z1MmEOBiNHWeaIf87025P07X7qWYRO40Gp
>
> Hmmm, that doesn't decode to a gzip compressed steam. But it
> doesn't decode to readable text either, so I have no clue
> what you encoded. Note that the pronounciation in the above
> question was on "gzipped", not on "B64-encoding".

You can't just throw a gzipped stream into a file and try to gunzip it.
I'm positive the data is gzipped, then base-64 encoded, because I use
this exact code to get it in there:

# Insert the response body if any

$zbody = MIME::Base64::encode_base64(Compress::Zlib::compress($resp->content()));

$sth = $dbh->prepare(qq{
INSERT INTO resp_body (resp, body) VALUES ($id, ?)
});
$sth->execute($zbody);

And I use the inverse to retrieve it.

> > I have increased the free space map and will be able to restart the
> > postmaster today at around midnight GMT.
>
> Any news?

I couldn't work it in to the last maintenance window. I'll give it
another run tonight.

Thanks again,
Jeffrey