Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Commit slower on faster PC
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Cc: "Koth, Christian (DWBI)" <Christian(dot)Koth(at)smiths-heimann(dot)com>
- Subject: Re: Commit slower on faster PC
- Date: Wed, 12 Jul 2006 10:46:05 -0700
- Message-id: <200607121046.05709.jd@commandprompt.com> <text/plain>
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/
- References:
- Commit slower on faster PC
- From: Koth, Christian (DWBI)
- Commit slower on faster PC
- Prev by Date: [Fwd: Delivery Status Notification (Failure)]
- Next by Date: size of pg_dump files containing bytea values
- Previous by thread: Re: Commit slower on faster PC
- Next by thread: Re: Commit slower on faster PC
- Indexes: