>I switched "in place" from beta2 to beta3 on windows some weeks ago
>(selfcompiled), no notable speed difference.
There may be a different issue here as well. The pginstaller version is
"beta3deva1", which is *not* beta3. It is a post-beta3 snapshot from oct
20th. If something has changed there,
I switched "in place" from beta2 to beta3 on windows some weeks ago
(selfcompiled), no notable speed difference.
Did you the usual "analyze" ritual???
Are the indexes used? Did you compare the "explain" outputs?
Are the indexes really present?
Harald
---(end of broadcast
Enrico Riedel wrote:
To the setup: I use the Win32 version of PGRE SQL8. The table that I am
working with has about 1.1M records in it and is indexed on several columns.
By searching the indexed columns the DB used to be very fast. The data
retrieval used to be more or less instantaneous. In Beta 3
