Re: How to store text files in the postgresql? - Mailing list pgsql-general

From Alan Hodgson
Subject Re: How to store text files in the postgresql?
Date
Msg-id 200906120846.39831@hal.medialogik.com
Whole thread Raw
In response to Re: How to store text files in the postgresql?  (Greg Stark <gsstark@mit.edu>)
Responses Re: How to store text files in the postgresql?
List pgsql-general
On Friday 12 June 2009, Greg Stark <gsstark@mit.edu> wrote:
> Also, it makes backups a pain since it's a lot easier to back up a
> file system than a database. But that gets back to whether you need
> transactional guarantees. The reason it's a pain to back up a database
> is precisely because it needs to make those guarantees.

It's far easier to backup and restore a database than millions of small
files. Small files = random disk I/O. The real downside is the CPU time
involved in storing and retrieving the files. If it isn't a show stopper,
then putting them in the database makes all kinds of sense.

--
WARNING:  Do not look into laser with remaining eye.

pgsql-general by date:

Previous
From: Bryan Murphy
Date:
Subject: Having trouble restoring our backups
Next
From: Alan Hodgson
Date:
Subject: Re: Having trouble restoring our backups