8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
| От | Souquieres Adam |
|---|---|
| Тема | 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory |
| Дата | |
| Msg-id | 5370C52B.8080006@axege.com обсуждение исходный текст |
| Ответы |
Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
|
| Список | 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 ?
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 ?
В списке pgsql-general по дате отправления: