Hi, On 2013-11-12 11:46:19 -0500, J Smith wrote: > > * Does SELECT count(*) FROM pg_prepared_xacts; return 0? > > Yes it does.
Could you show the output? Do you actually use prepared xacts actively? Do you actively use row level locking? Is there high concurrency in that environment? In short, could you describe your database usage a bit? Did you restart the database since getting the errors? > Latest checkpoint's NextXID: 0/5138174 > Latest checkpoint's NextOID: 3574036 > Latest checkpoint's NextMultiXactId: 5762623 > Latest checkpoint's NextMultiOffset: 11956824 > Latest checkpoint's oldestXID: 1673 > Latest checkpoint's oldestXID's DB: 1 > Latest checkpoint's oldestActiveXID: 5138174 > Latest checkpoint's oldestMultiXid: 1 Interesting. Pretty high multixact usage. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
