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
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
pgsql-performance by date
|Next:||From: Simon Riggs||Date: 2007-12-13 19:20:43|
|Subject: Re: Heavy write activity on first vacuum of fresh TOASTdata|
|Previous:||From: Tom Lane||Date: 2007-12-13 18:52:22|
|Subject: Re: Heavy write activity on first vacuum of fresh TOAST data |