Thread: 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

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@postgresql.org
>[mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf Of Randy Yu
>Sent: den 22 februari 2005 20:13
>To: 'pgsql-hackers-win32@postgresql.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
>