Skip site navigation (1) Skip section navigation (2)

Re: Getting Slow

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Joe Lester <joe_lester(at)sweetwater(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Getting Slow
Date: 2007-06-07 18:50:19
Message-ID: 20070607185019.GA26628@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2007-06-07 18:58:54
Subject: Re: Getting Slow
Previous:From: Andrew SullivanDate: 2007-06-07 18:37:48
Subject: Re: Getting Slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group