Skip site navigation (1) Skip section navigation (2)

Re: bytea or blobs?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Dana Hudes <dhudes(at)tcp-ip(dot)info>
Cc: Dana Hudes <dhudes(at)tcp-ip(dot)info>, pgsql-sql(at)postgresql(dot)org
Subject: Re: bytea or blobs?
Date: 2004-02-18 16:08:22
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
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

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-02-18 17:27:29
Subject: Re: [SQL] 7.4 - FK constraint performance
Previous:From: Stephan SzaboDate: 2004-02-18 16:03:36
Subject: Re: [SQL] 7.4 - FK constraint performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group