Re: work_mem in high transaction rate database

From: Akos Gabriel <akos(dot)gabriel(at)i-logic(dot)hu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: work_mem in high transaction rate database
Date: 2009-03-04 07:04:57
Message-ID: 20090304080457.50578136@gabriel-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tue, 3 Mar 2009 18:37:42 -0700 -n
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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(dot)gabriel(at)i-logic(dot)hu|Web: http://www.i-logic.hu=-
-=Tel/fax:+3612367353 |Mobil:+36209278894 =-

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri Fontaine 2009-03-04 09:16:07 Re: work_mem in high transaction rate database
Previous Message Scott Marlowe 2009-03-04 01:37:42 Re: work_mem in high transaction rate database