Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 262659FB2F8 for ; Mon, 23 Apr 2007 03:06:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 88551-07 for ; Mon, 23 Apr 2007 03:06:32 -0300 (ADT) X-Greylist: delayed 00:30:52.054537 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DC1CE9FB6B1 for ; Mon, 23 Apr 2007 03:06:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from fw-berlin.bund.de (mail1.bund.de [194.95.177.103]) by svr4.postgresql.org (Postfix) with ESMTP id 6C4C75AF024 for ; Mon, 23 Apr 2007 05:35:35 +0000 (GMT) Received: by fw-berlin.bund.de (8.13.8/8.11.6) id l3N5ZXdN006533 for pgsql-performance@postgresql.org; Mon, 23 Apr 2007 07:35:33 +0200 (CEST) Received: (from localhost) by m1.fw.bln.ivbb.bund.de (MSCAN) id 3/m1.fw.bln.ivbb.bund.de/smtp-gw/mscan; Mon Apr 23 07:35:33 2007 Date: Mon, 23 Apr 2007 07:39:02 +0200 (CEST) From: Andreas Tille X-X-Sender: tillea@wr-linux02 To: Sergey Tsukinovsky Cc: pgsql-performance@postgresql.org Subject: Re: postgres: 100% CPU utilization In-Reply-To: <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com> Message-Id: References: <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-OriginalArrivalTime: 23 Apr 2007 05:37:05.0677 (UTC) FILETIME=[6D6563D0:01C78569] X-TM-AS-Product-Ver: SMEX-7.0.0.1499-3.6.1039-15128.001 X-TM-AS-Result: No--0.342400-8.000000-31 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/385 X-Sequence-Number: 24262 On Thu, 19 Apr 2007, Sergey Tsukinovsky wrote: > I know that 7.0.2 is an old version and therefore ran the same test on > 7.3.18 - the performance behavior was similar. Why have you choosen just another very old version for performance comparison and not the latest stable release? Kind regards Andreas. -- http://fam-tille.de