Re: more about pg_toast growth
От | Jeffrey W. Baker |
---|---|
Тема | Re: more about pg_toast growth |
Дата | |
Msg-id | 1016217338.12395.42.camel@heat обсуждение исходный текст |
Ответ на | Re: more about pg_toast growth (Jan Wieck <janwieck@yahoo.com>) |
Ответы |
Re: more about pg_toast growth
|
Список | 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
В списке pgsql-general по дате отправления: