Re: Out of memory...

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Out of memory...
Дата
Msg-id 4F3E6BA3020000250004581A@gw.wicourts.gov
обсуждение исходный текст
Ответ на Out of memory...  ("Cassiano, Marco" <mcassiano@manord.com>)
Список pgsql-admin
"Cassiano, Marco" <mcassiano@manord.com> wrote:

> There was an autovaccum running on a big table saying it was "to
> avoid xid wraparound"

> My configuration is :
>
> Postgresql 9.1.2 compiled and running on Redhat 5 64 bit
> DB Size : about 100 GB
>
> RAM 5 GB
> Shared Buffers 1 GB
> temp_buffers = 8MB
> work_mem = 12MB
> maintenance_work_mem = 300MB

Are those the only settings changed from their defaults?  If not, or
you're not sure, please post the output from running the query on
this page:

http://wiki.postgresql.org/wiki/Server_Configuration

-Kevin

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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Big difference in databasesize compared with disksize
Следующее
От: Reinhard Asmus
Дата:
Сообщение: Re: Connections to the Database