Postgres Pro
Downloads
Home   >   mailing lists

Putting files into fields in a table - Mailing list pgsql-performance

From Campbell, Lance
Subject Putting files into fields in a table
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE8760197E3A@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: Putting files into fields in a table
List pgsql-performance
Tree view

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 memory.  The performance today is very good. 

 

Some questions I have:

 

What data type should I use for fields that hold files?

Is there anything that I should be aware of when putting files into a field in a table?

When PostgreSQL accesses a table that has fields that contain files does it put the fields that contain the files into the shared_buffers memory area?

 

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data
Next
From: Simon Riggs
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data