Message-ID: <4225955D.7090700@archonet.com>
Date: Wed, 02 Mar 2005 10:28:45 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
MIME-Version: 1.0
To: Mauro Bertoli <bertolima@yahoo.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres performance
References: <20050302093344.49749.qmail@web51404.mail.yahoo.com>
In-Reply-To: <20050302093344.49749.qmail@web51404.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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