Groups > comp.databases.postgresql > #628

Re: I saw the 40 cpu 150k transaction a second workup on freebsd

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!newsfeed.straub-nv.de!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: I saw the 40 cpu 150k transaction a second workup on freebsd
Date	Mon, 9 Feb 2015 05:23:33 +0000 (UTC)
Organization	A noiseless patient Spider
Lines	15
Message-ID	<pan.2015.02.09.05.24.09@gmail.com> (permalink)
References	<996e0d38-65de-4904-91f9-26f1df305290@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Date	Mon, 9 Feb 2015 05:23:33 +0000 (UTC)
Injection-Info	mx02.eternal-september.org; posting-host="9dbb49b777b4f27f09e09421fc52f8c8"; logging-data="15680"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19PNNcZl1ztJEwbK5vHt3kH"
User-Agent	Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock	sha1:toEwnjkHynKScw4xYGmVVuknFrY=
Xref	csiph.com comp.databases.postgresql:628

Show key headers only | View raw

On Mon, 02 Feb 2015 12:53:40 -0800, johannes falcone wrote:

> but where in general does one look to learn to tune the os for pg?

Well, there is an excellent Greg Smith's book about high performance 
PostgreSQL tuning. The book came out during the time of Pg 9.0, but is 
still relevant.



-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Je suis Charlie

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

I saw the 40 cpu 150k transaction a second workup on freebsd johannes falcone <visphatesjava@gmail.com> - 2015-02-02 12:53 -0800
  Re: I saw the 40 cpu 150k transaction a second workup on freebsd Mladen Gogala <gogala.mladen@gmail.com> - 2015-02-09 05:23 +0000

csiph-web