pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matt Clark <matt@ymogen.net>
To: Syd <569170@aliencamel.com>
To: pgsql-performance@postgresql.org
Subject: Re: insert speed - Mac OSX vs Redhat
Date: Thu, 15 Jan 2004 14:17:24 -0000
Message-ID: <OAEAKHEHCMLBLIDGAFELGEDPEHAA.matt@ymogen.net> (raw)
In-Reply-To: <A278005E-4762-11D8-BC83-00039398E788@aliencamel.com>

> 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.
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You haven't really produced much evidence to support that statement.  Given that the differences in performance between Postgres
running on *BSD and Linux on Intel hardware are not large at all, it seems to be almost certainly false in fact.

It may of course be due to some settings of the different OSes, but not the OSes themselves.

It would help if you gave a straight PG7.4 comparison with hardware specs as well, and config file differences if any.

One thought: assuming the Apple has IDE disks, then the disks probably have write caching turned on, which is good for speed, but
not crash-safe.

matt







view thread (4+ messages)  latest in thread

Message-ID: <OAEAKHEHCMLBLIDGAFELGEDPEHAA.matt@ymogen.net>
Permalink:  ../OAEAKHEHCMLBLIDGAFELGEDPEHAA.matt@ymogen.net/
Also on:    postgresql.org/message-id/OAEAKHEHCMLBLIDGAFELGEDPEHAA.matt@ymogen.net

 · 

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: matt@ymogen.net, 569170@aliencamel.com
  Subject: Re: insert speed - Mac OSX vs Redhat
  In-Reply-To: <OAEAKHEHCMLBLIDGAFELGEDPEHAA.matt@ymogen.net>

* 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