hi all,

i need help on this.. i'm experiencing this problem too often and i need a
permanent solution.

im using 7.3.4

..... config file

tcpip_socket = true
max_connections = 150
superuser_reserved_connections = 2

port = 5432
#shared_buffers = 45800
shared_buffers = 47900
sort_mem = 40000
#max_locks_per_transaction=160
max_locks_per_transaction=200

#fsync = true
#wal_sync_method = fsync

#
# Locale settings
#
# (initialized by initdb -- may be changed)
LC_MESSAGES = 'en_US.UTF-8'
LC_MONETARY = 'en_US.UTF-8'
LC_NUMERIC = 'en_US.UTF-8'
LC_TIME = 'en_US.UTF-8'

.... config ends

im having problems on our DB..

# update table_fan set active_flag='n' where num='12345678';

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


temporary solution:
restart the DB and all things went back to normal. trying the same SQL would
result to an update..

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

http://www.postgresql.org/docs/8.0/i...s.html#SYSVIPC


Thanks
Dinesh Pandey



-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailtogsql-general-owner@postgresql.org] On Behalf Of JM
Sent: Friday, April 22, 2005 2:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] ShmemAlloc: out of memory

hi all,

i need help on this.. i'm experiencing this problem too often and i
need a
permanent solution.

im using 7.3.4

..... config file

tcpip_socket = true
max_connections = 150
superuser_reserved_connections = 2

port = 5432
#shared_buffers = 45800
shared_buffers = 47900
sort_mem = 40000
#max_locks_per_transaction=160
max_locks_per_transaction=200

#fsync = true
#wal_sync_method = fsync

#
# Locale settings
#
# (initialized by initdb -- may be changed)
LC_MESSAGES = 'en_US.UTF-8'
LC_MONETARY = 'en_US.UTF-8'
LC_NUMERIC = 'en_US.UTF-8'
LC_TIME = 'en_US.UTF-8'

.... config ends

im having problems on our DB..

# update table_fan set active_flag='n' where num='12345678';

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


temporary solution:
restart the DB and all things went back to normal. trying the same SQL
would
result to an update..

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

JM <jerome@gmanmi.tv> writes:
> i need help on this.. i'm experiencing this problem too often and i need a
> permanent solution.

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

You probably need to increase max_locks_per_transaction some more.
It would also be a good idea to keep an eye on pg_locks and try to
figure out what's grabbing so many locks ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings