8.0.1 release performance on Window

Randy Yu <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <E705D2E9BE54784981F1862F701ADE790115EB85@edmexm01>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.