Re: more about pg_toast growth - Mailing list pgsql-general

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