Re: Large Objects - Mailing list pgsql-general

From Pierre-Frédéric Caillaud
Subject Re: Large Objects
Date
Msg-id opsj1h922pcq72hf@musicbox
Whole thread Raw
In response to Re: Large Objects  (Dan Boitnott <dan@mcneese.edu>)
List pgsql-general
> gives me (and those on high) the warm-fuzzies.  If I store files (PDFs
> of varying sizes by the way, say from 500k to 50M) as large objects,
> will I still be able to restore the _whole_ database from a single
> pg_dump tar file?

    Don't forget a thing :

    If you put a webserver in front of this, you will have to load the entire
object in RAM before you can serve it to the client, which means a little
number of requests on large files will kick the server into swapalot mode.
Using filesystem files solves this in the most easy of ways, but creates
backup problems, but it's not that complex.

pgsql-general by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Generating unique values for TEXT columns
Next
From: Peter Eisentraut
Date:
Subject: Re: Postgresql website issues.