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 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: 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 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