From: | "Campbell, Lance" <lance(at)uiuc(dot)edu> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Putting files into fields in a table |
Date: | 2007-12-13 19:10:28 |
Message-ID: | B10E6810AC2A2F4EA7550D072CDE8760197E3A@SAB-FENWICK.sab.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-12-13 19:20:43 | Re: Heavy write activity on first vacuum of fresh TOAST data |
Previous Message | Tom Lane | 2007-12-13 18:52:22 | Re: Heavy write activity on first vacuum of fresh TOAST data |