On 11/19/2015 12:29 PM, Bill Moran wrote:
> On Wed, 18 Nov 2015 20:10:00 -0500
> Jonathan Vanasco <postgres@2xlp.com> wrote:
>
>> As a temporary fix I need to write some uploaded image files to PostgreSQL until a task server can
read/process/deletethem.
>>
>> The problem I've run into (via server load tests that model our production environment), is that these read/writes
endup pushing the indexes used by other queries out of memory -- causing them to be re-read from disk. These files
canbe anywhere from 200k to 5MB.
> ... PostgreSQL doesn't have any provisions for preferring one thing or
> another for storing in memory. The easiest thing I can think would be
> to add memory to the machine (or configure Postgres to use more) such
> that those files aren't pushing enough other pages out of memory to
> have a problematic impact.
Perhaps this is just noise - but how is "just a" 5Mb file upload pushing
critical matter out of memory ? Throttle your file uploads ...
Roxanne