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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedJul 8, '11 at 12:08a
activeJul 8, '11 at 12:08a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Jtkells: 1 post

People

Translate

site design / logo © 2021 Grokbase