pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance on Win32 vs Cygwin
8+ messages / 6 participants
[nested] [flat]
* Performance on Win32 vs Cygwin
@ 2004-10-14 17:01 MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
2004-10-19 22:09 ` Re: [PERFORM] Performance on Win32 vs Cygwin Kevin Barnard <kevin.barnard@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: MikeSmialek2@Hotmail.com @ 2004-10-14 17:01 UTC (permalink / raw)
To: pgsql-performance; pgsql-hackers-win32@postgresql.org
Hi,
We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are
trying to determine why. Any info is appreciated.
We have a Web Server and a DB server both running Win2KServer with all
service packs and critical updates.
An ASP page on the Web Server hits the DB Server with a simple query that
returns 205 rows and makes the ASP page delivered to the user about 350K.
On an ethernet lan a client pc perceives just under 1 sec performance with
the following DB Server configuration:
PIII 550Mhz
256MB RAM
7200 RPM HD
cygwin
Postgresql 7.1.3
PGODBC 7.3.2
We set up another DB Server with 8 beta (same Web Server, same network, same
client pc) and now the client pc perceives response of just over 3 sec with
the following DB server config:
PIII 700 Mhz
448MB RAM
7200 RPM HD
8 Beta 2 Dev3 on Win32 running as a service
Is the speed decrease because it's a beta?
Is the speed decrease because it's running on Win instead of cygwin?
We did not install cygwin on the new DB Server.
Thanks,
Mike
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [PERFORM] Performance on Win32 vs Cygwin
2004-10-14 17:01 Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
@ 2004-10-19 22:09 ` Kevin Barnard <kevin.barnard@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Kevin Barnard @ 2004-10-19 22:09 UTC (permalink / raw)
To: MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>; +Cc: PostgreSQL <pgsql-general@postgresql.org>
Have you looked at the 7.3 configuration file vs. the 8.0. It's
possible that the 7.3 file is tweakled better then the 8.0. Have you
anaylzed the tables after loading the data into 8.0
On Thu, 14 Oct 2004 12:01:38 -0500, MikeSmialek2@Hotmail.com
<mikesmialek2@hotmail.com> wrote:
> Hi,
>
> We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are
> trying to determine why. Any info is appreciated.
>
> We have a Web Server and a DB server both running Win2KServer with all
> service packs and critical updates.
>
> An ASP page on the Web Server hits the DB Server with a simple query that
> returns 205 rows and makes the ASP page delivered to the user about 350K.
>
> On an ethernet lan a client pc perceives just under 1 sec performance with
> the following DB Server configuration:
> PIII 550Mhz
> 256MB RAM
> 7200 RPM HD
> cygwin
> Postgresql 7.1.3
> PGODBC 7.3.2
>
> We set up another DB Server with 8 beta (same Web Server, same network, same
> client pc) and now the client pc perceives response of just over 3 sec with
> the following DB server config:
> PIII 700 Mhz
> 448MB RAM
> 7200 RPM HD
> 8 Beta 2 Dev3 on Win32 running as a service
>
> Is the speed decrease because it's a beta?
> Is the speed decrease because it's running on Win instead of cygwin?
>
> We did not install cygwin on the new DB Server.
>
> Thanks,
>
> Mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Performance on Win32 vs Cygwin
@ 2004-10-14 17:29 Magnus Hagander <mha@sollentuna.net>
2004-10-14 19:40 ` Re: Performance on Win32 vs Cygwin Reini Urban <rurban@x-ray.at>
2004-10-14 21:45 ` Re: Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: Magnus Hagander @ 2004-10-14 17:29 UTC (permalink / raw)
To: MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>; pgsql-performance; pgsql-hackers-win32@postgresql.org
>Hi,
>
>We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are
>trying to determine why. Any info is appreciated.
>
>We have a Web Server and a DB server both running Win2KServer with all
>service packs and critical updates.
>
>An ASP page on the Web Server hits the DB Server with a simple
>query that
>returns 205 rows and makes the ASP page delivered to the user
>about 350K.
>
>On an ethernet lan a client pc perceives just under 1 sec
>performance with
>the following DB Server configuration:
> PIII 550Mhz
> 256MB RAM
> 7200 RPM HD
> cygwin
> Postgresql 7.1.3
> PGODBC 7.3.2
>
>We set up another DB Server with 8 beta (same Web Server, same
>network, same
>client pc) and now the client pc perceives response of just
>over 3 sec with
>the following DB server config:
> PIII 700 Mhz
> 448MB RAM
> 7200 RPM HD
> 8 Beta 2 Dev3 on Win32 running as a service
>
>Is the speed decrease because it's a beta?
>Is the speed decrease because it's running on Win instead of cygwin?
>
>We did not install cygwin on the new DB Server.
IIRC, previous versions of postgresql (< 8.0) did not correctly sync
disks when running on Cygwin. I'm not 100% sure, can someone confirm?
8.0 does, and I beleive it does both under native win32 and cygwin.
It's been my experience that the native version is slightly faster than
the cygwin one, but I've only compared 8.0 to 8.0.
//Magnus
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Performance on Win32 vs Cygwin
2004-10-14 17:29 Re: Performance on Win32 vs Cygwin Magnus Hagander <mha@sollentuna.net>
@ 2004-10-14 19:40 ` Reini Urban <rurban@x-ray.at>
1 sibling, 0 replies; 8+ messages in thread
From: Reini Urban @ 2004-10-14 19:40 UTC (permalink / raw)
To: pgsql-hackers-win32@postgresql.org; +Cc: pgsql-performance
Magnus Hagander schrieb:
> IIRC, previous versions of postgresql (< 8.0) did not correctly sync
> disks when running on Cygwin. I'm not 100% sure, can someone confirm?
> 8.0 does, and I beleive it does both under native win32 and cygwin.
yes, sync is a NOOP on cygwin.
> It's been my experience that the native version is slightly faster than
> the cygwin one, but I've only compared 8.0 to 8.0.
Sure. This is expected. Cygwin's interim's layer costs a lot of time.
(process handling, path resolution)
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Performance on Win32 vs Cygwin
2004-10-14 17:29 Re: Performance on Win32 vs Cygwin Magnus Hagander <mha@sollentuna.net>
@ 2004-10-14 21:45 ` MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
2004-10-15 15:37 ` Re: Performance on Win32 vs Cygwin Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 8+ messages in thread
From: MikeSmialek2@Hotmail.com @ 2004-10-14 21:45 UTC (permalink / raw)
To: Magnus Hagander <mha@sollentuna.net>; pgsql-performance; pgsql-hackers-win32@postgresql.org
Thanks Magnus,
So are we correct to rely on
- 8 being slower than 7.x in general and
- 8 on Win32 being a little faster than 8 on Cygwin?
Will the final release of 8 be faster than the beta?
Thanks,
Mike
----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "MikeSmialek2@Hotmail.com" <mikesmialek2@hotmail.com>;
<pgsql-performance@postgresql.org>; <pgsql-hackers-win32@postgresql.org>
Sent: Thursday, October 14, 2004 12:29 PM
Subject: SV: [pgsql-hackers-win32] Performance on Win32 vs Cygwin
>Hi,
>
>We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are
>trying to determine why. Any info is appreciated.
>
>We have a Web Server and a DB server both running Win2KServer with all
>service packs and critical updates.
>
>An ASP page on the Web Server hits the DB Server with a simple
>query that
>returns 205 rows and makes the ASP page delivered to the user
>about 350K.
>
>On an ethernet lan a client pc perceives just under 1 sec
>performance with
>the following DB Server configuration:
> PIII 550Mhz
> 256MB RAM
> 7200 RPM HD
> cygwin
> Postgresql 7.1.3
> PGODBC 7.3.2
>
>We set up another DB Server with 8 beta (same Web Server, same
>network, same
>client pc) and now the client pc perceives response of just
>over 3 sec with
>the following DB server config:
> PIII 700 Mhz
> 448MB RAM
> 7200 RPM HD
> 8 Beta 2 Dev3 on Win32 running as a service
>
>Is the speed decrease because it's a beta?
>Is the speed decrease because it's running on Win instead of cygwin?
>
>We did not install cygwin on the new DB Server.
IIRC, previous versions of postgresql (< 8.0) did not correctly sync
disks when running on Cygwin. I'm not 100% sure, can someone confirm?
8.0 does, and I beleive it does both under native win32 and cygwin.
It's been my experience that the native version is slightly faster than
the cygwin one, but I've only compared 8.0 to 8.0.
//Magnus
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Performance on Win32 vs Cygwin
2004-10-14 17:29 Re: Performance on Win32 vs Cygwin Magnus Hagander <mha@sollentuna.net>
2004-10-14 21:45 ` Re: Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
@ 2004-10-15 15:37 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Tom Lane @ 2004-10-15 15:37 UTC (permalink / raw)
To: MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>; +Cc: Magnus Hagander <mha@sollentuna.net>; pgsql-performance; pgsql-hackers-win32@postgresql.org
"MikeSmialek2@Hotmail.com" <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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Performance on Win32 vs Cygwin
@ 2004-10-15 16:22 Merlin Moncure <merlin.moncure@rcsonline.com>
2004-10-15 17:55 ` Re: [PERFORM] Performance on Win32 vs Cygwin Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Merlin Moncure @ 2004-10-15 16:22 UTC (permalink / raw)
To: MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>; +Cc: pgsql-hackers-win32@postgresql.org; pgsql-performance; Magnus Hagander <mha@sollentuna.net>
> Thanks Magnus,
>
> So are we correct to rely on
> - 8 being slower than 7.x in general and
> - 8 on Win32 being a little faster than 8 on Cygwin?
>
> Will the final release of 8 be faster than the beta?
I'm pretty certain that previous to 8.0 no win32 based postgesql
properly sync()ed the files. Win32 does not have sync(), and it is
impossible to emulate it without relying on the application to track
which files to sync. 8.0 does this because it fsync()s the files
individually. Therefore, benchmarking fsync=on on 8.0 to a <8.0 version
of windows is not apples to apples. This includes, by the way, the SFU
based port of postgresql because they didn't implement sync() there,
either.
Other than the sync() issue, the cygwin/win32 i/o performance should be
roughly equal. Unless I'm terribly mistaken about things, all the i/o
calls should boil down to win32 api calls.
The cygwin IPC stack is implemented differently...pg 8.0 win32 native
version does all the ipc stuff by hand, so you might get slightly
different behavior there.
Merln
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [PERFORM] Performance on Win32 vs Cygwin
2004-10-15 16:22 Re: Performance on Win32 vs Cygwin Merlin Moncure <merlin.moncure@rcsonline.com>
@ 2004-10-15 17:55 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Tom Lane @ 2004-10-15 17:55 UTC (permalink / raw)
To: Merlin Moncure <merlin.moncure@rcsonline.com>; +Cc: MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>; pgsql-hackers-win32@postgresql.org, pgsql-performance@postgresql.org, "Magnus Hagander" <mha@sollentuna.net>
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> I'm pretty certain that previous to 8.0 no win32 based postgesql
> properly sync()ed the files. Win32 does not have sync(), and it is
> impossible to emulate it without relying on the application to track
> which files to sync. 8.0 does this because it fsync()s the files
> individually. Therefore, benchmarking fsync=on on 8.0 to a <8.0 version
> of windows is not apples to apples. This includes, by the way, the SFU
> based port of postgresql because they didn't implement sync() there,
> either.
This is all true, but for performance testing I am not sure that you'd
notice much difference, because the sync or lack of it only happens
within checkpoints.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2004-10-19 22:09 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-14 17:01 Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
2004-10-19 22:09 ` Kevin Barnard <kevin.barnard@gmail.com>
2004-10-14 17:29 Re: Performance on Win32 vs Cygwin Magnus Hagander <mha@sollentuna.net>
2004-10-14 19:40 ` Reini Urban <rurban@x-ray.at>
2004-10-14 21:45 ` MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
2004-10-15 15:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-15 16:22 Re: Performance on Win32 vs Cygwin Merlin Moncure <merlin.moncure@rcsonline.com>
2004-10-15 17:55 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox