Re: Performance on Win32 vs Cygwin

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "MikeSmialek2(at)Hotmail(dot)com" <mikesmialek2(at)hotmail(dot)com>
Cc: "Magnus Hagander" <mha(at)sollentuna(dot)net>, pgsql-performance(at)postgresql(dot)org, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Performance on Win32 vs Cygwin
Date: 2004-10-15 15:37:40
Message-ID: 9631.1097854660@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-performance

"MikeSmialek2(at)Hotmail(dot)com" <mikesmialek2(at)hotmail(dot)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

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Merlin Moncure 2004-10-15 16:22:40 Re: Performance on Win32 vs Cygwin
Previous Message MikeSmialek2@Hotmail.com 2004-10-14 21:45:51 Re: Performance on Win32 vs Cygwin

Browse pgsql-performance by date

  From Date Subject
Next Message Doug Y 2004-10-15 16:07:27 Tuning shared_buffers with ipcs ?
Previous Message Michael Nonemacher 2004-10-15 14:17:06 Re: Select with qualified join condition / Batch inserts