out of memory during query execution

Поиск
Список
Период
Сортировка
От DANTE ALEXANDRA
Тема out of memory during query execution
Дата
Msg-id 43A6BBDD.2050008@BULL.NET
обсуждение исходный текст
Ответы Re: out of memory during query execution  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

I am a PostGreSQL newbie. I work with the 8.1.0 release on AIX 5.3, with
300GB of datas.
Some of the queries launched on this database finish with an "*out of
memory*". The queries which have failed contain a lot of join (between 6
tables), sub-select and aggregate. For these queries, the log file
contains :
psql:Q9.sql:40: ERROR:  out of memory
DETAIL:  Failed on request of size 148.

On the server used, I got 3GB of memory and 1 CPU.
The settings specified in the "postgresql.conf" are :
# - Memory -
shared_buffers = 12288
#temp_buffers = 1000
#max_prepared_transactions = 5
work_mem = 65536
maintenance_work_mem = 262144
max_stack_depth = 24574

Are some of these values false?
Is the "out of memory" error due to smaller memory available ?
Has somenone ever seen this problem ?

Thank you for your help.

Regards,
Alexandra DANTE

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: is this a bug or I am blind?
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: One DB not backed up by pg_dumpall