Re: 0ut of Memory Error during Vacuum Analyze and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 0ut of Memory Error during Vacuum Analyze and
Дата
Msg-id 26905.1140734819@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 0ut of Memory Error during Vacuum Analyze and  ("Tomeh, Husam" <htomeh@firstam.com>)
Список pgsql-performance
"Tomeh, Husam" <htomeh@firstam.com> writes:
> When I first connect to the database via "psql" and issue the "create
> index" statement, of course,  I get the "out of memory" error. If I
> don't quit my current session and re-ran the same DDL statement again,
> the index gets created successfully!.. However, if after my first
> unsuccessful run, I exit my session and re-connect again, and then run
> the DDL, it will fail again and get the same error. I have done that for
> many times and appears to have a consistent pattern of behavior.

Now that you know how to reproduce it, please have another go at getting
that stack trace.  The palloc printout certainly looks like some kind of
memory-leak issue, but I can't tell more than that from it.

            regards, tom lane

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

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: 0ut of Memory Error during Vacuum Analyze and
Следующее
От: Brendan Duddridge
Дата:
Сообщение: Really really slow query. What's a better way?