Very large record sizes and resource usage

Поиск
Список
Период
Сортировка
От jtkells@verizon.net
Тема Very large record sizes and resource usage
Дата
Msg-id g6ic17pnltbr4nd7gerhp2m574j1q8cfl4@4ax.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: D C
Дата:
Сообщение: "VACUUM FULL ANALYZE" vs. Autovacuum Contention
Следующее
От: Vincent de Phily
Дата:
Сообщение: Re: [GENERAL] DELETE taking too much memory