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

insert speed - Mac OSX vs Redhat

From: Syd <569170(at)aliencamel(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: insert speed - Mac OSX vs Redhat
Date: 2004-01-15 13:56:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
I've read most of the threads on insert speed in this list and wanted 
to share some interesting observations and a question.

We've been benchmarking some dbs to implement Bayesian processing on an 
email server. This involves frequent insert and updates to the 
following table:

create table bayes_token (
username varchar(200) not null default '',
token varchar(200) not null default '',
spam_count integer not null default 0,
ham_count integer not null default 0,
atime integer not null default 0,
primary key (username, token));

On a variety of hardware with Redhat, and versions of postgres, we're 
not getting much better than 50 inserts per second. This is prior to 
moving WAL to another disk, and fsync is on.

However, with postgres 7.4 on Mac OSX 10.2.3, we're getting an amazing 
500 inserts per second.

We can only put this down to the OS.

Can anyone shed light on why Redhat appears to be so much poorer than 
Mac OS X in supporting postgres insert transactions? Or why MacOS 
appears to be so much better?

BTW, on the same hardware that postgres is running on to get 50 inserts 
per sec, MySQL (4.0.17) is getting an almost unbelievable 5,500 inserts 
per second.



pgsql-performance by date

Next:From: Matt ClarkDate: 2004-01-15 14:17:24
Subject: Re: insert speed - Mac OSX vs Redhat
Previous:From: pginfoDate: 2004-01-15 13:13:15
Subject: Trigger question

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