Re: 8.0.1 release performance on Window

It sounds like you were running without fsync() in the beta4 release.
Any chance your config is different? Are your datafiles on the same
directory?

//Magnus

>-----Original Message-----
>From: pgsql-hackers-win32-owner(at)postgresql(dot)org
>[mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf Of Randy Yu
>Sent: den 22 februari 2005 20:13
>To: 'pgsql-hackers-win32(at)postgresql(dot)org'
>Subject: [pgsql-hackers-win32] 8.0.1 release performance on Window
>
>
>I has been using 8.0.0beta 4 for some performance testing and
>have great
>result.
>After migrated to 8.0.1 release, I saw a drop of 10 fold in
>performance.
>A large import and update of 10,000 record use to take 1 hr with beta 4
>With 8.0.1 release, it take 10 hours to do the exact same task.
>Both install is the default install from PGInstall with no tunning.
>Any help in explaining this change in performance will be greatly
>appreciated.
>Thanks
>Randy
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index
>scan if your
> joining column's datatypes do not match
>