Re: Memory Errors...
От | Shridhar Daithankar |
---|---|
Тема | Re: Memory Errors... |
Дата | |
Msg-id | 3D8A2B00.1328.144C37EF@localhost обсуждение исходный текст |
Ответ на | Memory Errors... ("Ian Harding" <ianh@tpchd.org>) |
Список | pgsql-general |
On 19 Sep 2002 at 7:10, Ian Harding wrote: > Can someone tell me what these mean? They happen when running big ugly pgtcl functions that delete, insert and updatelots of stuff in the database. > ERROR: Memory exhausted in AllocSetContextCreate(8192) > ERROR: Memory exhausted in AllocSetAlloc(88) > ERROR: Memory exhausted in AllocSetAlloc(60) > options SHMMAXPGS=8192 # 1024 pages is the default > which I thing brings my maximum amount of shared memory from about 4 MB to about 32 MB. (256 MB is installed) I thenchanged the line in postgresql.conf like this: > > shared_buffers = 3000 # 2*max_connections, min 16 > > which I think says "PostgreSQL, there is about 24 MB of shared memory available to you." > > You would think this would be better, not worse, than the defaults. Now you have recompiled the kernel, does postgres works same way with defaults? Let's change one thing at a time.. HTH Bye Shridhar -- The Gordian Maxim: If a string has one end, it has another.
В списке pgsql-general по дате отправления: