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 Aulak
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
scr
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
ame data and I have run
vacuumdb -f -z on the databases.
Now I have read something on the archives that stated that perhaps the data
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 Messag
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 m