very large record sizes and ressource usage

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

Предыдущее
От: vincent dephily
Дата:
Сообщение: DELETE taking too much memory
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: [GENERAL] DELETE taking too much memory