Re: Problem creating index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem creating index
Дата
Msg-id 66555.1377534140@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problem creating index  (Torello Querci <tquerci@gmail.com>)
Ответы Re: Problem creating index  (Torello Querci <tquerci@gmail.com>)
Список pgsql-general
Torello Querci <tquerci@gmail.com> writes:
> 2013/8/26 Luca Ferrari <fluca1978@infinito.it>
>> Is it possible to test with an incremented work_mem value?

> Actually I use the default work_set value (1MB).

maintenance_work_mem is what would be used for CREATE INDEX.

FWIW, though, the combination of this weird error and the fact that you
had a corrupt index to begin with makes me suspicious that there's some
low-level problem.  You might be well advised to do some memory testing
on that machine, for example.

            regards, tom lane


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

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