Tue, 3 Mar 2009 18:37:42 -0700 -n Scott Marlowe <scott.marlowe@xxxxxxxxx> írta: > Oh my lord, that is a foot gun waiting to go off. Assuming 2k > connections, and somehow a fair number of them went active with big I absolutely agree with Scott. Plus set effective_cache_size accordingly, this would help the planner. You can read a lot about setting this in the mailing list archives. -- Üdvözlettel, Gábriel Ákos -=E-Mail :akos.gabriel@xxxxxxxxxx|Web: http://www.i-logic.hu=- -=Tel/fax:+3612367353 |Mobil:+36209278894 =- -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
