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: [email protected] 
>[mailto:[email protected]] On Behalf Of Randy Yu
>Sent: den 22 februari 2005 20:13
>To: '[email protected]'
>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
>

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [email protected] so that your
      message can get through to the mailing list cleanly