On Wed, Nov 18, 2015 at 5:10 PM, Jonathan Vanasco <postgres@xxxxxxxx> wrote: > 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 up pushing the indexes used by other queries out of memory -- causing them to be re-read from disk. These files can be anywhere from 200k to 5MB. Are you storing them as large object, or as bytea? Can you share the load testing scripts? Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
