Postgres Pro
Downloads
Home   >   mailing lists

controlling memory management with regard to a specific query (or groups of connections) - Mailing list pgsql-general

From Jonathan Vanasco
Subject controlling memory management with regard to a specific query (or groups of connections)
Date
Msg-id 70B71B25-DE3F-46F3-832A-E3D27486C8FB@2xlp.com
Whole thread Raw
Responses Re: controlling memory management with regard to a specific query (or groups of connections)
Re: controlling memory management with regard to a specific query (or groups of connections)
Re: controlling memory management with regard to a specific query (or groups of connections)
List pgsql-general
Tree view 
As a temporary fix I need to write some uploaded image files to PostgreSQL until a task server can read/process/delete
them.  

The problem I've run into (via server load tests that model our production environment), is that these read/writes end
uppushing the indexes used by other queries out of memory -- causing them to be re-read from disk.   These files can be
anywherefrom 200k to 5MB. 

has anyone dealt with situations like this before and has any suggestions?  I could use a dedicated db connection if
thatwould introduce any options.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.
Next
From: Roxanne Reid-Bennett
Date:
Subject: Re: controlling memory management with regard to a specific query (or groups of connections)