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

From Greg Stark
Subject Re: How to store text files in the postgresql?
Date
Msg-id 407d949e0906120707o5c21ee52o7e706e89a3e7448f@mail.gmail.com
Whole thread Raw
In response to Re: How to store text files in the postgresql?  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
Responses Re: How to store text files in the postgresql?
List pgsql-general
This is a recurring debate and there are pros and cons for both sides.
It usually comes down to whether you need transactional guarantees for
these large objects.

There are also practical concerns. Transfering these large objects
over a single database tcp connection limits the application
performance a lot. And the database is often more heavyweight than you
really want to keep tied up to serve up images.

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.

pgsql-general by date:

Previous
From: "James B. Byrne"
Date:
Subject: Re: search for partial dates
Next
From: Scott Ribe
Date:
Subject: Re: How to store text files in the postgresql?