Re: Problem creating index

Поиск
Список
Период
Сортировка
От Torello Querci
Тема Re: Problem creating index
Дата
Msg-id CA+igE6QmRD3osKc8shuaPkD2UVXmtb1NQkGqQGWkjd-RCKFGPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem creating index  (Luca Ferrari <fluca1978@infinito.it>)
Ответы Re: Problem creating index
Re: Problem creating index
Список pgsql-general
Дерево обсуждения

2013/8/26 Luca Ferrari <fluca1978@infinito.it>
On Mon, Aug 26, 2013 at 4:27 PM, Torello Querci <tquerci@gmail.com> wrote:
> ERROR:  unexpected end of tape

Really strange, if I get it right something went wrong while sorting tuples.
Is it possible to test with an incremented work_mem value?

Actually I use the default work_set value (1MB).
Of course it is possible increase work_set value to any values. 
Now I'll try with 10MB (shared_buffers is set to 412MB).
If you think that 10MB is a very low value for a table with million of records I can try to increase work_set value to higher value.

Best Regards, Torello


В списке pgsql-general по дате отправления:

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: Problem creating index
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: What is the relationship between checkpoint and wal