Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7CA659FC0EA for ; Thu, 7 Jun 2007 15:50:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 42328-06 for ; Thu, 7 Jun 2007 15:50:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 2C81E9FBFEF for ; Thu, 7 Jun 2007 15:50:22 -0300 (ADT) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1HwN3r-0000tJ-Ra; Thu, 07 Jun 2007 20:50:20 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1HwN3r-0006xE-00; Thu, 07 Jun 2007 20:50:19 +0200 Date: Thu, 7 Jun 2007 20:50:19 +0200 From: "Steinar H. Gunderson" To: Joe Lester Cc: pgsql-performance@postgresql.org Subject: Re: Getting Slow Message-ID: <20070607185019.GA26628@uio.no> Mail-Followup-To: Joe Lester , pgsql-performance@postgresql.org References: <14D118F0-20F6-4096-93D7-E6CB2893E895@sweetwater.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <14D118F0-20F6-4096-93D7-E6CB2893E895@sweetwater.com> X-Operating-System: Linux 2.6.20.4 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/138 X-Sequence-Number: 25171 On Thu, Jun 07, 2007 at 01:48:43PM -0400, Joe Lester wrote: > - The server log shows frequent "archived transaction log file" > entries. Usually once every 10 minutes or so, but sometimes 2 or 3 > per minute. Sounds like you've got a lot of writes going. You might want more power in your I/O? > Operating System: Mac OS 10.4.7 Client Is there a particular reason for this? It's not known to be the best server OS around -- it's hard to say that an OS change would do anything for your problem, but it looks like an unusual choice. /* Steinar */ -- Homepage: http://www.sesse.net/