Very large record sizes and resource usage - Mailing list pgsql-performance

From jtkells@verizon.net
Subject Very large record sizes and resource usage
Date
Msg-id g6ic17pnltbr4nd7gerhp2m574j1q8cfl4@4ax.com
Whole thread Raw
List pgsql-performance
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 more specifically dumping these records (table)
using pg_dump

Thanks

pgsql-performance by date:

Previous
From: D C
Date:
Subject: "VACUUM FULL ANALYZE" vs. Autovacuum Contention
Next
From: Vincent de Phily
Date:
Subject: Re: [GENERAL] DELETE taking too much memory