storing files: blob, toasted text of filesystem?

From: "Joolz" <joolz(at)arbodienst-limburg(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: storing files: blob, toasted text of filesystem?
Date: 2004-10-03 08:48:25
Message-ID: 64413.80.126.234.5.1096793305.squirrel@webmail.arbodienst-limburg.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

Sorry if this is a FAQ, but I've groups.googled the subject and
can't find a definite answer (if such a thing exists). I'm working
on a db in postgresql on a debian stable server, ext3 filesystem.
The db will contain files, not too many (I expect somewehere between
10 and 100 files max to be inserted daily), and not too big (mostly
pdf files, some images. The size will rarely be larger than 1Mb).

My plan was to store the files in the db as BLOBs, which seemed the
most elegant solution because these files are logically related to
objects that are in the db (customers, people etc.) Recently someone
warned me that this would have a large performance impact on the db
and said it's better to store the files on the filesystem and keep
some sort of pointer in the db.

Google was contradictory, some people even had performance problems
when using the filesystem/pointer approach and went to BLOBs for
that reason. Can anyone tell me (or point me in the right direction)
what is the best way to do this, BLOBs / filesystem+pointer /
toasted text?

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kristian Rink 2004-10-03 10:34:57 Re: storing files: blob, toasted text of filesystem?
Previous Message David Garamond 2004-10-03 04:41:40 Re: about "pg_dump " without pompt password