Re: work_mem in high transaction rate database - Mailing list pgsql-performance

From Akos Gabriel
Subject Re: work_mem in high transaction rate database
Date
Msg-id 20090304080457.50578136@gabriel-laptop
Whole thread Raw
In response to Re: work_mem in high transaction rate database  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Tue, 3 Mar 2009 18:37:42 -0700 -n
Scott Marlowe <scott.marlowe@gmail.com> í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@i-logic.hu|Web:  http://www.i-logic.hu=-
-=Tel/fax:+3612367353            |Mobil:+36209278894         =-

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: work_mem in high transaction rate database
Next
From: Dimitri Fontaine
Date:
Subject: Re: work_mem in high transaction rate database