I currently have a Postgres 7.3 database running under WIN2K using cygwin
and want to move to Postgres 8.0.3 (native windows version).
I am finding most simple queries are significantly faster on the native
windows version compared to 7.3 (under cygwin).
However, for a complex query, that involve
is in the filesystem (not database) cache. Would this be the case?. If so
how would I improve the performance under WIN2K?
Anyone have any ideas?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Gurpreet
Aulakh
Sent: September 21, 2005 12:38 PM
To: pgsql-performance
sure the locale was set
to C and that the encoding was SQL_ASCII. (these are the settings on the
cygwin installation).
I still get the same results in the last post.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: September 21, 2005 8:13 PM
To: Gurpreet Aulakh
Cc: pgsql
After further investigation I have found that the reason why the query is
slower on 8.0.3 is that the hash and hash joins are slower on the 8.0.3.
So the question comes down to : Why are hash and hash joins slower? Is this
a postgres configuration setting that I am missing? Is the locale still
be moving to it when it's
officially released.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: September 23, 2005 2:13 PM
To: Gurpreet Aulakh
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)
Gurpreet Aulakh [EMAIL