hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > while I understand it, and will pass this information to client, one > thing bugs me - one the problem happens only sometimes, with relatively > low count of backends? > we saw database running normally with 1200 connections, yet sometimes, > it has 500 connections, and then something happens and they all end up > locking in this parse mode. Well, if they're all busy, you're not going to get this cache reset problem. It's idle backends that have fallen behind that create the problem. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
