Re: URGENT: Performance tuning

As I wrote,
I do not make any changes in the default setup.
I make the test with index and got the same result.
On Oracle I do not have any indexes created.

Can you point me to any good structured docs about performance tuning in postgres.
Also what is the goot time that i can expect for this test.
If you have good worked and tuned postgres, can you make this test on your compute (it is very simple) and
replay the results?
I nedd this info to know if it is possible to get more from posgres or to go to oracle integration.
My wish is to work with postgres!

thanks.
Ericson Smith <eric(at)did-it(dot)com> wrote: On Thu, 2002-06-20 at 14:45, Joshua D. Drake wrote:
> Hello,
>
> Did you create an index? What is your shared buffers? Are you using
> Fsync, if so --- which one?

The default shared buffers that come with pgsql is very small. So you
need to really ramp this up. Read the article for some more tips. Also
check the techdocs.postgresql.org site for some good info.

For this purpose, you have to have indexes, yes.

I did not change my default Fsync settings, which i think mainly applies
to updates anyway.

- Ericson Smith
eric(at)did-it(dot)com
http://www.did-it.com
>
>
>
>
> 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)
> >
> >
>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup