Help!!! FreeSpaceMap hashtalble out of memory.

From: "Yurgis Baykshtis" <ybaykshtis(at)micropat(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Help!!! FreeSpaceMap hashtalble out of memory.
Date: 2003-10-21 19:56:12
Message-ID: 002d01c3980d$6183f2e0$a5936e3f@aurigin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Cygwin, 7.3.4
This thing is really KILLING us and our customers.

In pgerr.log this always go together:

WARNING: ShmemAlloc: out of memory
ERROR: FreeSpaceMap hashtable out of memory

Theses errors usually take place on INSERT statements like this one:

INSERT INTO params (param_id,map_id,param_key,param_value) VALUES
(0,858,'MAP_NAME','New Map')

params is just a simple table (no triggers or rules involved):
CREATE TABLE map_11.params
(
param_id int4 NOT NULL,
map_id int4 NOT NULL,
param_key varchar(1024),
param_value text,
CONSTRAINT params_pkey PRIMARY KEY (param_id)
) WITH OIDS;

The db server machine has 4GB of physical memory and more than half is
always available.
Number of connection is 64
Number of buffers was increased to 81920 (but this does not help)

Is there any parameters that can be configured to increase available shared
memory size?

Any help is greatly appreciated.

Attachment Content-Type Size
winmail.dat application/ms-tnef 2.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bob Badour 2003-10-21 20:10:21 Re: Dreaming About Redesigning SQL
Previous Message Bruce Momjian 2003-10-21 19:50:52 Re: [HACKERS] Mapping Oracle types to PostgreSQL types