From: Richard Huxton <dev@archonet.com>
To: Dana Hudes <dhudes@tcp-ip.info>
Cc: Dana Hudes <dhudes@tcp-ip.info>
Cc: pgsql-sql@postgresql.org
Subject: Re: bytea or blobs?
Date: Wed, 18 Feb 2004 16:08:22 +0000
Message-ID: <200402181608.22966.dev@archonet.com> (raw)
In-Reply-To: <Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info>
References: <E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com>
<200402180944.42239.dev@archonet.com>
<Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info>
On Wednesday 18 February 2004 15:17, Dana Hudes wrote:
> How can one measure the result of the compression -- can I see this in
> some table or with some pgsql command?
Hmm - not so far as I know.
> At what threshold does it take place, I think its 8192?
> The nasty bit is not one picture of 100kb.
> Its 20 pictures of 5kb.
I'd have thought 5KB would trigger it - 8192 is the limit for a row (which
TOASTing is designed to remove). There are/were some technical notes on TOAST
when it was being built/introduced - googling might well find them.
What I'd suggest is grab some suitably representative images, base64 encode
them and see how much it takes to store 100,000 copies of them.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, dhudes@tcp-ip.info
Subject: Re: bytea or blobs?
In-Reply-To: <200402181608.22966.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox