From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Ericson Smith <eric(at)did-it(dot)com> |
Cc: | Peter Dimov <jquest_j(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: URGENT: Performance tuning |
Date: | 2002-06-20 18:45:02 |
Message-ID: | 3D1222AE.901@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
Did you create an index? What is your shared buffers? Are you using
Fsync, if so --- which one?
Ericson Smith wrote:
>http://phpbuilder.com/columns/smith20010821.php3
>
>On Thu, 2002-06-20 at 13:21, Peter Dimov wrote:
>
>
>>Hi ,
>>
>>I need info about how to fine tune my postgresql.
>>
>>I make a little test and the results was not good for posgresql.
>>
>>I will to use the server in production and need this info.
>>
>>So, the test:
>>
>>first machine:
>>
>>Linux Mandrake 8.2 and posgresql on it.
>>
>>Dual Athlon MP 1,6 GHz , 1 GB RAM , IDE 7200 40 GB HDD.
>>
>>
>>
>>I create a litle table (field1 varchar(100),field2 varchar(100), field3 int) and fill
>>
>>200 000 x ('aaaaaaaaaaaaa1','bbbbbbbbbbbbbbb1',10);
>>
>>200 000 x ('aaaaaaaaaaaaa2','bbbbbbbbbbbbbbb2',20);
>>
>>200 000 x ('aaaaaaaaaaaaa3','bbbbbbbbbbbbbbb3',30);
>>
>>200 000 x ('aaaaaaaaaaaaa4','bbbbbbbbbbbbbbb4',40);
>>
>>200 000 x ('aaaaaaaaaaaaa5','bbbbbbbbbbbbbbb5',50);
>>
>>
>>
>>After that i make : select distinct field1 from mytable.
>>
>>As result I get 5 rows and it is OK, but the time is 3 min 30 sec.
>>
>>The processor usage is 50% - it is OK , and the system use the maximum of the first processor.
>>
>>The second machine:
>>
>>Athlon XP 1,5 GHz , 512 MB RAM , 7200 HDD 40 GB
>>
>>WinNT 4, Oracle 8i.
>>
>>I make the same test.
>>
>>The result come for 15 sec !!!!.
>>
>>Ok, I am sure : the diferent can not be so big.
>>
>>I do not make any special setup an postgres and on linux, anly the standart install.
>>
>>Any info or example will be great.
>>
>>Many thanks in advance.
>>
>>
>>
>>
>>
>>
>>
>>---------------------------------
>>Do You Yahoo!?
>>Sign-up for Video Highlights of 2002 FIFA World Cup
>>
>>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Elmshauser, Erik | 2002-06-20 18:46:43 | selecting all records where a column is null |
Previous Message | Andrew Sullivan | 2002-06-20 18:44:09 | Re: URGENT: Performance tuning |