CLUSTER using more memory than expected

Поиск
Список
Период
Сортировка
От Joshua Marsh
Тема CLUSTER using more memory than expected
Дата
Msg-id 38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com
обсуждение исходный текст
Ответы Re: CLUSTER using more memory than expected  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: CLUSTER using more memory than expected  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-admin
The CLUSTER function seems to be using more memory than I expect.  Here is what I get from top and from my config file:

from top:
27589 postgres  25   0 3943m 3.6g  11m R 99.9 61.6 639:19.41 postgres: postgres data 127.0.0.1(42126) CLUSTER

from postgresql.conf
shared_buffers = 1000 #26214            # min 16, at least max_connections*2, 8KB each
work_mem = 256000               # min 64, size in KB
maintenance_work_mem = 2097151  # min 1024, size in KB
#max_stack_depth = 2048         # min 100, size in KB

My version is: 8.0.3

Any ideas why this would be happening.  I tried a full restart and the same thing happens.

Thanks,

Josh


--
This E-mail is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521 and is legally privileged.

This information is confidential information and is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

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

Предыдущее
От: Luís Sousa
Дата:
Сообщение: pg_restore inside a transaction block
Следующее
От: Luís Sousa
Дата:
Сообщение: pg_restore and drop table problems