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

Re: General performance questions about postgres on Apple

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Sean Shanny <shannyconsulting(at)earthlink(dot)net>,"scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: General performance questions about postgres on Apple
Date: 2004-02-23 20:11:17
Message-ID: 200402231211.17369.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Scott,

> I am certainly open to any suggestions on how to deal with speed issues 
> on these sorts of large tables, it isn't going to go away for us. :-( 

I'm not sure what to suggest.   I can't think of anything off the top of my 
head that would improve cripplingly slow random seek times.

This sort of problem has personally caused me to dump and replace various RAID 
controllers in the past.   I have to say that I have not been impressed with 
the Mac as a database server platform in the past; I've had no end of issues 
with memory and disk management.

I talked to the Apple Server staff at the last MacWorld about some of these 
issues and they admitted that servers are still a "new thing" for Apple as a 
company, and they're still tweaking OSX server.

BTW, I wasn't clear from your description: did you mean that you have 14 
disks?

Oh, and for testing real random seek time, you can run bonnie++ which is 
findable on freshmeat.   This should give you a benchmark to e-mail the Apple 
people.   I'd be interested in being cc'd on your communications with them, 
as we use OSX for webserving and would like to see better support for 
database serving.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

pgsql-performance by date

Next:From: Simon RiggsDate: 2004-02-24 00:17:28
Subject: Re: General performance questions about postgres on Apple hardware...
Previous:From: Josh BerkusDate: 2004-02-23 20:04:18
Subject: Re: Slow join using network address function

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