From: Ben Trewern <ben.trewern@mowlem.com>
To: pgsql-performance@postgresql.org
Subject: Re: performances with Pentium D
Date: Thu, 1 Mar 2007 11:00:38 -0000
Message-ID: <es6bon$tb6$1@news.hub.org> (raw)
References: <1172678294.544317.195100@t69g2000cwt.googlegroups.com>
I suspect the difference is your disk subsystem. IDE disks (in your laptop
I assume) quite often (almost always!!) ignore fsync calls and return as
soon as the data gets to the disk cache, not the physical disk. SCSI disks
are almost always more correct, and wait until the data gets to the physical
disk before they return from an fsync call.
I hope this helps.
Regards,
Ben
"hatman" <joel.winteregg@gmail.com> wrote in message
news:1172678294.544317.195100@t69g2000cwt.googlegroups.com...
Hi all,
Do someone already had some problem with performances using a pentium
D (64 bits) and postgres 8.2.3 on a redhat enterprise update 2 ?
I did the install from sources and nothing change... I have a RAID 0
for data and 3Gb of RAM and my inserts rate is quite low, 8333 inserts/
sec (lower than on my laptop which is 10526 inserts/sec).
I suspect a problem with the CPU because using gkrellm, the use of 1
CPU is always quite low... Is it normal ?
Many thanks for your help,
Joël
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: ben.trewern@mowlem.com
Subject: Re: performances with Pentium D
In-Reply-To: <es6bon$tb6$1@news.hub.org>
* 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