PostgreSQL: 8.2
I am looking at the possibility of storing files in some of my database
tables. My concern is obviously performance. I have configured
PostgreSQL to take advantage of Linux file caching. So my PostgreSQL
does not have a large setting for shared_buffers even though I have 24G
of
On 12/13/07, Campbell, Lance [EMAIL PROTECTED] wrote:
I am looking at the possibility of storing files in some of my database
tables. My concern is obviously performance. I have configured PostgreSQL
to take advantage of Linux file caching. So my PostgreSQL does not have a
large setting for
-performance@postgresql.org
Subject: Re: [PERFORM] Putting files into fields in a table
On 12/13/07, Campbell, Lance [EMAIL PROTECTED] wrote:
I am looking at the possibility of storing files in some of my
database
tables. My concern is obviously performance. I have configured
PostgreSQL
to take
Campbell, Lance wrote:
I did not see much info in the 8.2 documentation on BLOB.
That's because we don't call them blobs. Search for large objects
instead:
http://www.postgresql.org/docs/current/static/largeobjects.html
--
Alvaro Herrera
13, 2007 2:22 PM
To: Campbell, Lance
Cc: pgsql-performance@postgresql.org list
Subject: Re: [PERFORM] Putting files into fields in a table
On Dec 13, 2007, at 2:09 PM, Campbell, Lance wrote:
I did not see much info in the 8.2 documentation on BLOB. I did ready
about bytea or binary data type