From: | Jan Wieck <janwieck(at)yahoo(dot)com> |
---|---|
To: | "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org> |
Cc: | Jan Wieck <janwieck(at)yahoo(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: more about pg_toast growth |
Date: | 2002-03-15 14:47:23 |
Message-ID: | 200203151447.g2FElNZ05279@saturn.janwieck.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Laurent N | 2002-03-15 15:01:32 | Few administrative questions |
Previous Message | Enrico Mangano | 2002-03-15 14:28:02 | R: [SQL] UPDATE and SELECT result difference |