Re: 8.0.1 release performance on Window

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Randy Yu" <RYu(at)sagebrushcorp(dot)com>, <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: 8.0.1 release performance on Window
Date: 2005-02-22 19:34:00
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE476963@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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
>

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2005-02-22 20:50:10 Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32
Previous Message Randy Yu 2005-02-22 19:12:38 8.0.1 release performance on Window