Re: URGENT: Performance tuning
От | Ericson Smith |
---|---|
Тема | Re: URGENT: Performance tuning |
Дата | |
Msg-id | 1024595677.2860.22.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | URGENT: Performance tuning (Peter Dimov <jquest_j@yahoo.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: