Re: [PERFORM] very large record sizes and ressource usage

2011-07-28 Thread Robert Haas
On Thu, Jul 7, 2011 at 10:33 AM, wrote: > Is there any guidelines to sizing work_mem, shared_bufferes and other > configuration parameters etc., with regards to very large records?  I > have a table that has a bytea column and I am told that some of these > columns contain over 400MB of data.  I

[PERFORM] very large record sizes and ressource usage

2011-07-07 Thread jtkells
Is there any guidelines to sizing work_mem, shared_bufferes and other configuration parameters etc., with regards to very large records? I have a table that has a bytea column and I am told that some of these columns contain over 400MB of data. I am having a problem on several servers reading and