Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6208763271D for ; Sat, 12 Jun 2010 09:10:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 92795-05 for ; Sat, 12 Jun 2010 12:10:08 +0000 (UTC) X-Greylist: delayed 00:06:12.35761 by SQLgrey-1.7.6 Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com [74.125.82.46]) by mail.postgresql.org (Postfix) with ESMTP id 9C4936322C9 for ; Sat, 12 Jun 2010 09:10:09 -0300 (ADT) Received: by wwb18 with SMTP id 18so1859566wwb.19 for ; Sat, 12 Jun 2010 05:10:07 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.174.142 with SMTP id x14mr483258wel.8.1276344190157; Sat, 12 Jun 2010 05:03:10 -0700 (PDT) Received: by 10.216.171.70 with HTTP; Sat, 12 Jun 2010 05:03:10 -0700 (PDT) Date: Sat, 12 Jun 2010 14:03:10 +0200 Message-ID: Subject: ~400 TPS - good or bad? From: Szymon Kosok To: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/221 X-Sequence-Number: 39077 Hello, We are trying to optimize our box for Postgresql. We have i7, 8GB of ram, 2xSATA RAID1 (software) running on XFS filesystem. We are running Postgresql and memcached on that box. Without any optimizations (just edited PG config) we got 50 TPS with pg_bench default run (1 client / 10 transactions), then we've added to /home partition (where PGDATA is) logbuf=8 and nobarrier. With that fs setup TPS in default test is unstable, 150-300 TPS. So we've tested with -c 100 -t 10 and got stable ~400 TPS. Question is - is it decent result or we can get much more from Postgres on that box setup? If yes, what we need to do? We are running Gentoo. Here's our config: http://paste.pocoo.org/show/224393/ PS. pgbench scale is set to "1". -- Greetings, Szymon