Re: URGENT: Performance tuning - Mailing list pgsql-general

Hi ,

Curt, thanks for answer.

I am realy new to postgres. I try it from 3-4 moths.

But I am not new to databases and SQL and I know very good how good is all

working on oracle or ms sql ( I do not love it).

You are in pricpe right, I can change the hardware and I make it.

First I tested with P II 400 MHz 256 MB RAM.

And second Dual Athlon MP , 1.6 GHz , 1 or 2 GB RAM.

I expected to get big advantage from the second system and

was very supprise from the results : I wan only 30 - 40% faster as the first.

After that I make the described test and compare all to oracle.

But I will be realy happy to get postgres working well and I will continue to search

the answer.

It is not possible to develope a db system so many yers as postgres development team and to

so big performance diferent to oracle.

Ok, I know oracle is comersial .

I think the mistake is by tuning or by version, but can not be in the postgres.

regards and thanks.

  Curt Sampson <cjs@cynic.net> wrote:

On Sat, 22 Jun 2002, Peter Dimov wrote:

> I do not have any answer on my
> questin: Is postgres good as performace compared to oracle...

The answer to that is, "it depends." Some applications will work
just as well, others will not.

> ...and if yes how to fine tune it.

A few points on tuning:

1. Try to use tests that reflect as accurately as possible what
your application will do, and try to tune your application as well.
For example, if your application really does do 25,000 inserts in
a single transaction, perhaps it would be better off using the COPY
command instead.

2. When you're new to postgres, or any database system, it will
take time and experimentation before you figure out the system's
idiosyncrasies and learn how to tune it. If you really need to be
up and running right away, you should probably just go out and buy
the system you're most familiar with.

3. Becuase you're saving so much money in software costs, you may
have a bit of extra money to throw at hardware. So you should
consider perhaps adding a few more disks to your system, and moving
at least the log files on to a separate disk.

> And the second question: Was enyone from the list a good perofmed
> postgres and if yes can I receiv this test result.

Yes, I've gotten excellent performance out of postgres from time
to time. However, the test results would be meaningless for you;
they probably don't relate to your application at all.

cjs
--
Curt Sampson +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC