Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-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

pgsql-performance by date

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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group