X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D20079FA5E6 for ; Sun, 11 Jun 2006 19:01:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 61362-01 for ; Sun, 11 Jun 2006 19:01:40 -0300 (ADT) X-Greylist: delayed 00:18:58.367688 by SQLgrey- Received: from ls405.htnet.hr (ls405.t-com.hr [195.29.150.135]) by postgresql.org (Postfix) with ESMTP id C1D929F9CAA for ; Sun, 11 Jun 2006 19:01:40 -0300 (ADT) Received: from ls422.t-com.hr (ls422.t-com.hr [195.29.150.237]) by ls405.htnet.hr (Postfix) with ESMTP id 2D8261443F4; Sun, 11 Jun 2006 23:42:40 +0200 (CEST) Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1]) by ls422.t-com.hr (Qmlai) with ESMTP id CB812C90048; Sun, 11 Jun 2006 23:42:39 +0200 (CEST) X-Envelope-Sender: mario.splivalo@mobart.hr X-Envelope-Sender: mario.splivalo@mobart.hr Received: from 89-172-6-239.adsl.net.t-com.hr (89-172-6-239.adsl.net.t-com.hr [89.172.6.239])by ls422.t-com.hr (Qmlai) with ESMTP id 2819F1308042;Sun, 11 Jun 2006 23:42:36 +0200 (CEST) Subject: Re: scaling up postgres From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: "Steinar H. Gunderson" Cc: pgsql-performance@postgresql.org In-Reply-To: <20060603094355.GA23297@uio.no> References: <200606030931.k539V38Y007877@smtp2.planet.net.tn> <20060603094355.GA23297@uio.no> Content-Type: text/plain Organization: Mob-Art Date: Sun, 11 Jun 2006 23:42:20 +0200 Message-Id: <1150062140.23423.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-imss-version: 2.040 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/123 X-Sequence-Number: 19480 On Sat, 2006-06-03 at 11:43 +0200, Steinar H. Gunderson wrote: > On Sat, Jun 03, 2006 at 10:31:03AM +0100, fzied@planet.tn wrote: > > I do have 2 identical beasts (4G - biproc Xeon 3.2 - 2 Gig NIC) > > One beast will be apache, and the other will be postgres. > > I'm using httperf/autobench for measurments and the best result I can get > > is that my system can handle a trafiic of almost 1600 New con/sec. > > What version of PostgreSQL? (8.1 is better than 8.0 is much better than 7.4.) > Have you remembered to turn HT off? Have you considered Opterons instead of > Xeons? (The Xeons generally scale bad with PostgreSQL.) What kind of queries Could you point out to some more detailed reading on why Xeons are poorer choice than Opterons when used with PostgreSQL? Mario