Home > mailing lists

Re: High SYS CPU - need advise - Mailing list pgsql-general

From	Vlad
Subject	Re: High SYS CPU - need advise
Date	November 24, 2012 21:24:08
Msg-id	CAKeSUqVnRJ6bZoMqBSY=q3gax9dj4Zw7drRghTJFChm-NT6VJg@mail.gmail.com Whole thread Raw
In response to	Re: High SYS CPU - need advise (Merlin Moncure <mmoncure@gmail.com>)
List	pgsql-general

what pgbouncer mode, and how large is your pool.

'-M prepared' produces normal results, while '-M simple' results in 40% sys cpu. '-M extended' is somewhere in between.

I'm running it as 60 clients, 2 threads.

-- Vlad

From: Jeff Janes
Date: 24 November 2012, 21:23:57
Subject: Re: High SYS CPU - need advise

From: Christian Hammers
Date: 24 November 2012, 23:14:27
Subject: How and for what to use SP-GIST?