From: Richard Huxton <dev@archonet.com>
To: Mauro Bertoli <bertolima@yahoo.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres performance
Date: Wed, 02 Mar 2005 10:28:45 +0000
Message-ID: <4225955D.7090700@archonet.com> (raw)
In-Reply-To: <20050302093344.49749.qmail@web51404.mail.yahoo.com>
References: <20050302093344.49749.qmail@web51404.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, bertolima@yahoo.it
Subject: Re: Postgres performance
In-Reply-To: <4225955D.7090700@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox