8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory

From: Souquieres Adam <adam(dot)souquieres(at)axege(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Date: 2014-05-12 12:57:15
Message-ID: 5370C52B.8080006@axege.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

we have a problem since we migrate from 8.4 to 9.1

when we play : ANALYSE VERBOSE; ( stat on all databases, with 500 tables
and 1to DATA in all tables)

we now have this message :

org.postgresql.util.PSQLException: ERROR: out of shared memory Indice
: You might need to increase max_locks_per_transaction.

When we was in 8.4, there was no error,

there is our specific postgresql.conf configuration on the server :

default_statistics_target = 200
maintenance_work_mem = 1GB
constraint_exclusion = on
checkpoint_completion_target = 0.9
effective_cache_size = 7GB
work_mem = 48MB
wal_buffers = 32MB
checkpoint_segments = 64
shared_buffers = 2304MB
max_connections = 150
random_page_cost = 2.0
max_locks_per_transaction = 128 # was at default val ( 64?), we already
try to increase it without sucess

Have you any suggestions ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2014-05-12 13:21:03 Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Previous Message Felix Kunde 2014-05-12 09:18:13 comparing two JSON objects in 9.3