Dear List,
Today morning at 01:00 AM in our PostgreSQL 9.0.3 server a routine
maintenance script has started (vacuumdb --all --full --analyze), and
stopped with this error:
sqlstate=23505ERROR: duplicate key value violates unique constraint
pg_index_indexrelid_index
sqlstate=23505DETAIL: Key
Hi,
Check the postgresql.conf file, and the maximum connection settings... Or
check the postgresql.log for other errors, but it seems to me the maximum
connection will be the problem...
Regards,
Cvc
On 2011.04.12. 11:07, AI Rumman rumman...@gmail.com wrote:
I am connecting to Postgresql 9 from
Hi,
I've got an IBM x3200 server, with 1,8 Ghz dual core processor, and with 4
GB RAM. I've installed a FreeBSD 8.2, PostgreSQL 9.0.3, Apache22, with
php5.3.5 and extensions for postgre, session,pdf and others.
After the install, I recieved lot of too many user in the postgresql.log,
and after
/ADD TABLE stuck: I realized, that the locks number is so high, what
about these settings:
deadlock_timeout = 1s
max_locks_per_transaction = 64
is it ok? or is it too high?
Thanks,
Carl
2011/4/8 Vick Khera vi...@khera.org
On Fri, Apr 8, 2011 at 4:00 AM, Gipsz Jakab clausewit...@gmail.comwrote
a shorter
time period for the idle time or less lock time?
regards,
Carl
2011/4/8 Merlin Moncure mmonc...@gmail.com
On Fri, Apr 8, 2011 at 3:00 AM, Gipsz Jakab clausewit...@gmail.com
wrote:
After the settings in the postgresql.conf our system is much faster, and
no
more error messages
Ok Vick, thanks, and sorry for the off-list message.
regards,
Carl
2011/4/8 Vick Khera vi...@khera.org
On Fri, Apr 8, 2011 at 9:53 AM, Gipsz Jakab clausewit...@gmail.comwrote:
Thanks Vick, I'll try it tonight. I will give 1024 shared_buffers and
maintenance_work_mem, and 102 MB of work_mem