Postgres Pro
Downloads
Home   >   mailing lists

very large record sizes and ressource usage - Mailing list pgsql-performance

From jtkells@verizon.net
Subject very large record sizes and ressource usage
Date
Msg-id pqgb17p8h6nqrdfrpgfgcrit9h3nfvvqnf@4ax.com
Whole thread Raw
Responses Re: very large record sizes and ressource usage
List pgsql-performance
Tree view 
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: vincent dephily
Date:
Subject: DELETE taking too much memory
Next
From: Guillaume Lelarge
Date:
Subject: Re: [GENERAL] DELETE taking too much memory