From: Ulrich Cech <ulrich-news@cech-privat.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Large objetcs performance
Date: Sat, 21 Apr 2007 09:27:03 +0200
Message-ID: <4629BCC7.1090900@cech-privat.de> (raw)
In-Reply-To: <26551fb50704040703n75d9b8d9p7ab4bf11109dfe63@mail.gmail.com>
References: <26551fb50704040703n75d9b8d9p7ab4bf11109dfe63@mail.gmail.com>
Hello Alexandre,
<We have an application subjected do sign documents and store them
somewhere.>
I developed a relative simple "file archive" with PostgreSQL (web
application with JSF for user interface). The major structure is one
table with some "key word fields", and 3 blob-fields (because exactly 3
files belong to one record). I have do deal with millions of files (95%
about 2-5KB, 5% are greater than 1MB).
The great advantage is that I don't have to "communicate" with the file
system (try to open a directory with 300T files on a windows system...
it's horrible, even on the command line).
The database now is 12Gb, but searching with the web interface has a
maximum of 5 seconds (most searches are faster). The one disadvantage is
the backup (I use pg_dump once a week which needs about 10 hours). But
for now, this is acceptable for me. But I want to look at slony or port
everything to a linux machine.
Ulrich
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: ulrich-news@cech-privat.de
Subject: Re: Large objetcs performance
In-Reply-To: <4629BCC7.1090900@cech-privat.de>
* 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