X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 319CB8B9EA8 for ; Wed, 23 Feb 2005 14:38:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17563-04 for ; Wed, 23 Feb 2005 14:38:00 +0000 (GMT) Received: from mail.logi-track.com (www.logi-track.com [213.239.193.212]) by svr1.postgresql.org (Postfix) with ESMTP id 5C6808B9EA1 for ; Wed, 23 Feb 2005 14:38:02 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (J064b.j.pppool.de [85.74.6.75]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logi-track.com (Postfix) with ESMTP id B18A8307F7; Wed, 23 Feb 2005 15:38:00 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id CE679AB286; Wed, 23 Feb 2005 15:37:54 +0100 (CET) Message-ID: <421C953C.4040907@logi-track.com> Date: Wed, 23 Feb 2005 15:37:48 +0100 From: Markus Schaber User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Magnus Hagander Cc: "Vig, Sandor (G/FI-2)" , pgsql-performance@postgresql.org Subject: Re: PostgreSQL is extremely slow on Windows References: <6BCB9D8A16AC4241919521715F4D8BCE476962@algol.sollentuna.se> In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE476962@algol.sollentuna.se> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enig58AF062D4A9664305F60E24A" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.053 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/319 X-Sequence-Number: 10648 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig58AF062D4A9664305F60E24A Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, Magnus & all, Magnus Hagander schrieb: > 20-30 transactionsi s about what you'll get on a single disk on Windows= > today. > We have a patch in testing that will bring this up to about 80. > You can *never* get above 80 without using write cache, regardless of > your OS, if you have a single disk. You might want to look into wether > write cacheing is enabled on your linux box, and disable it. (unless yo= u > are using RAID) A lot points towards write cache enabled on your system= =2E Note that you can get higher rates for the server as a whole when using concurrent transactions (that is, several independend connections committing at the same time). The commit delay settings should be tuned accordingly. Markus --=20 markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 z=FCrich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com --------------enig58AF062D4A9664305F60E24A Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCHJVCOVWsnapT9i0RA+MMAKDUwJAc2MC5OZRzJrhL2WaNi6MIIgCgr8ng /b8INAO6V8wAEeZ0EHVScZU= =nAMz -----END PGP SIGNATURE----- --------------enig58AF062D4A9664305F60E24A--