X-Original-To: pgsql-hackers-win32-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C014B32BEB1 for ; Fri, 15 Oct 2004 16:37:50 +0100 (BST) 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 65540-04 for ; Fri, 15 Oct 2004 15:37:45 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id B4C4232BE65 for ; Fri, 15 Oct 2004 16:37:44 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9FFbeBe009632; Fri, 15 Oct 2004 11:37:40 -0400 (EDT) To: "MikeSmialek2@Hotmail.com" Cc: "Magnus Hagander" , pgsql-performance@postgresql.org, pgsql-hackers-win32@postgresql.org Subject: Re: Performance on Win32 vs Cygwin In-reply-to: References: <6BCB9D8A16AC4241919521715F4D8BCE475EE5@algol.sollentuna.se> Comments: In-reply-to "MikeSmialek2@Hotmail.com" message dated "Thu, 14 Oct 2004 16:45:51 -0500" Date: Fri, 15 Oct 2004 11:37:40 -0400 Message-ID: <9631.1097854660@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200410/71 X-Sequence-Number: 2361 "MikeSmialek2@Hotmail.com" writes: > So are we correct to rely on > - 8 being slower than 7.x in general and I think this is a highly unlikely claim ... *especially* if you are comparing against 7.1. The point about sync() being a no-op is real, but offhand I think it would only come into play at checkpoints. We have never issued sync() during regular queries. What seems more likely to me is that you have neglected to do any performance tuning on the new installation. Have you vacuumed/analyzed all your tables? Checked the postgresql.conf settings for sanity? If you'd like to do an apples-to-apples comparison to prove whether 7.1's failure to sync() is relevant, then turn off fsync in the 8.0 configuration and see how much difference that makes. If you can identify specific queries that are slower in 8.0 than 7.1, I'd be interested to see the EXPLAIN ANALYZE details from each. (Actually, I'm not sure 7.1 had EXPLAIN ANALYZE; you may have to settle for EXPLAIN from it.) regards, tom lane