Postgres Pro
Downloads
Home   >   mailing lists

Re: Commit slower on faster PC - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Commit slower on faster PC
Date
Msg-id 200607121046.05709.jd@commandprompt.com
Whole thread Raw
In response to Commit slower on faster PC  ("Koth, Christian (DWBI)" <Christian.Koth@smiths-heimann.com>)
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: "Steve McWilliams"
Date:
Subject: size of pg_dump files containing bytea values
Next
From: "Craig A. James"
Date:
Subject: [Fwd: Delivery Status Notification (Failure)]