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"
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. It seems like it would work for
storing files. I guess I could stick with the OS for file storage but
it is a pain. It would be easier
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 http://www.flickr.com/phot
Cc: pgsql-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 conf
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 settin
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
