[PERFORM] Very large record sizes and resource usage

2011-07-10 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

[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