pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar@frodo.hserus.net>
To: Jesper Krogh <jesper@krogh.cc>
Cc: pgsql-performance@postgresql.org
Subject: Re: Storing binary data.
Date: Wed, 11 Aug 2004 20:42:50 +0530
Message-ID: <200408112042.50356.shridhar@frodo.hserus.net> (raw)
In-Reply-To: <cfdagq$lol$1@sea.gmane.org>
References: <cfdagq$lol$1@sea.gmane.org>

On Wednesday 11 Aug 2004 7:59 pm, Jesper Krogh wrote:
> The "common" solution, I guess would be to store them in the filesystem
> instead, but I like to have them just in the database it is nice clean
> database and application design and if I can get PostgreSQL to "not
> cache" them then it should be excactly as fast i assume.

You can normalize them so that a table contains an id and a bytea column only. 
Te main table will contain all the other attributes and a mapping id. That 
way you will have only the main table cached.

You don't have to go to filesystem for this, I hope.

HTH

 Shridhar



view thread (5+ messages)  latest in thread

Message-ID: <200408112042.50356.shridhar@frodo.hserus.net>
Permalink:  ../200408112042.50356.shridhar@frodo.hserus.net/
Also on:    postgresql.org/message-id/200408112042.50356.shridhar@frodo.hserus.net

 · 

reply

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-performance@postgresql.org
  Cc: shridhar@frodo.hserus.net, jesper@krogh.cc
  Subject: Re: Storing binary data.
  In-Reply-To: <200408112042.50356.shridhar@frodo.hserus.net>

* 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