Re: more about pg_toast growth

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".

>
> > [...]
> > hour? Man, who is writing all that text?
>
> Reuters.

Ah :-)

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

Any news?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com