From: Joshua D. Drake <jd@commandprompt.com>
To: pgsql-performance@postgresql.org
Cc: Koth, Christian (DWBI) <Christian.Koth@smiths-heimann.com>
Subject: Re: Commit slower on faster PC
Date: Wed, 12 Jul 2006 10:46:05 -0700
Message-ID: <200607121046.05709.jd@commandprompt.com> (raw)
In-Reply-To: <F5F602C218633C419C7BCA6CDDC6E90A023A996F@COSSMGMBX04.EMAIL.CORP.TLD>
References: <F5F602C218633C419C7BCA6CDDC6E90A023A996F@COSSMGMBX04.EMAIL.CORP.TLD>
On Wednesday 12 July 2006 09:16, Koth, Christian (DWBI) wrote:
> Hi,
>
> please help me with the following problem:
>
> I have noticed a strange performance behaviour using a commit statement on
> two different machines. On one of the machines the commit is many times
> faster than on the other machine which has faster hardware. Server and
> client are running always on the same machine.
>
> Server version (same on both machines): PostgreSQL 8.1.3. (same binaries as
> well)
Heh, I bet you are being bit by the cache on the IDE drive. What happens if
you turn fsync off?
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
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: jd@commandprompt.com, Christian.Koth@smiths-heimann.com
Subject: Re: Commit slower on faster PC
In-Reply-To: <200607121046.05709.jd@commandprompt.com>
* 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