| From: | "Joshua D(dot) 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: | 2006-07-12 17:46:05 |
| Message-ID: | 200607121046.05709.jd@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve McWilliams | 2006-07-12 18:36:27 | size of pg_dump files containing bytea values |
| Previous Message | Stefan Kaltenbrunner | 2006-07-12 17:39:30 | Re: Kill a session |