Re: Postgres performance

Mauro Bertoli wrote:
> Hi, thanks a lot! you are rigth, but I did read your
> message ;)
> Yes,
> 1- I misconfigured PostgreSQL (I thought that was
> already configured in base to the released version -
> Fedora Core 3 64bit).
> 2- The bench is, clearly after your precisations, an
> MySQL tuned application tests.
> 3- I think the bench test only one connection, I
> didn't see (in a fast reading) no threading request in
> the bench code to simulate users requests.
> 4- I didn't test transaction-safe (that isn't used
> explicitly in my application)

Well, do you care whether your data is consistent or not? If not, you
don't need transactions.

> I understand it isn't simple.. I use the dbms in data
> analysis environment and the more time is spent in
> query (php is 0.1%) with more sub-selects and maybe
> there's, in the same time, from 1 to 1000 users
> insert/update data. I tests the dbms with my data
> analysis framework simulating an super-extensive
> request.

You'll find inserts/updates with lots of users is where PostgreSQL works
well compared to other systems.

> Do you know where I can find an tutorial to configure
> hardware dependent Postgres internal values?

There's some useful stuff here:
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
and also here:
http://www.powerpostgresql.com/PerfList

--
Richard Huxton
Archonet Ltd