Re: out of memory woes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: out of memory woes
Дата
Msg-id 21351.1166113630@sss.pgh.pa.us
обсуждение исходный текст
Ответ на out of memory woes  ("Angva" <angvaw@gmail.com>)
Список pgsql-general
"Angva" <angvaw@gmail.com> writes:
> As I've mentioned in a few other posts, I run a daily job that loads
> large amounts of data into a Postgres database. It must run
> efficiently, so one of the tricks I do is run table loads, and commands
> such as cluster, in parallel. I am having a problem where my cluster
> job consistently fails with an out of memory error.

Could we see the actual error message?  If it's a server-side error
then there should also be a memory context dump into the postmaster
log, which would be useful to see also.  Lastly, please show the full
schema definition (including indexes) for the troublesome tables.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.2 server core dump
Следующее
От: "Brandon Aiken"
Дата:
Сообщение: Re: out of memory woes