Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


>-----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
>After migrated to 8.0.1 release, I saw a drop of 10 fold in 
>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
>---------------------------(end of 
>TIP 9: the planner will ignore your desire to choose an index 
>scan if your
>      joining column's datatypes do not match

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group