pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: Joe Lester <joe_lester@sweetwater.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Getting Slow
Date: Thu, 7 Jun 2007 20:50:19 +0200
Message-ID: <20070607185019.GA26628@uio.no> (raw)
In-Reply-To: <14D118F0-20F6-4096-93D7-E6CB2893E895@sweetwater.com>
References: <14D118F0-20F6-4096-93D7-E6CB2893E895@sweetwater.com>

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/



view thread (7+ messages)  latest in thread

Message-ID: <20070607185019.GA26628@uio.no>
Permalink:  ../20070607185019.GA26628@uio.no/
Also on:    postgresql.org/message-id/20070607185019.GA26628@uio.no

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sgunderson@bigfoot.com, joe_lester@sweetwater.com
  Subject: Re: Getting Slow
  In-Reply-To: <20070607185019.GA26628@uio.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox