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

From Jan Wieck
Subject Re: more about pg_toast growth
Date
Msg-id 200203151447.g2FElNZ05279@saturn.janwieck.net
Whole thread Raw
In response to Re: more about pg_toast growth  ("Jeffrey W. Baker" <jwbaker@acm.org>)
Responses Re: more about pg_toast growth
List pgsql-general
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@Yahoo.com #



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


pgsql-general by date:

Previous
From: "Enrico Mangano"
Date:
Subject: R: [SQL] UPDATE and SELECT result difference
Next
From: "Evandro"
Date:
Subject: Drop all databases objects except the database