From: Mauro Bertoli <bertolima@yahoo.it>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres performance
Date: Wed, 2 Mar 2005 12:24:56 +0100 (CET)
Message-ID: <20050302112456.79149.qmail@web51406.mail.yahoo.com> (raw)
In-Reply-To: <4225955D.7090700@archonet.com>
Hi Richard, thank you for your apreciated answers!!!
- start quote -
Well, do you care whether your data is consistent or
not? If not, you
don't need transactions.
- end quote -
I don't require transaction because the query aren't
complex and update a single tuple (in SELECT
transactions are useless)
- start quote -
You'll find inserts/updates with lots of users is
where PostgreSQL works
well compared to other systems.
- end quote -
Uhhmm.. this is interesting...
- tutorial links -
Thx, now I read it and test an hardware tuned
configuration... I read that is not very simple... :O
Another question:
- why postgres release aren't already configured
(hardware tuning)? isn't possible configure it during
installation?
- why postgres use a new process for every query ?
(mySQL, if I'm not wrong, use threads... I think its
faster)
- why connection time is slower? (compared to mySQL)?
- why postgres require analyze? (mySQL, if I'm not
wrong, don't require it)
Yours answers will be very apreciated! Thx
___________________________________
Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… Scaricalo ora!
http://it.messenger.yahoo.it
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: bertolima@yahoo.it, dev@archonet.com
Subject: Re: Postgres performance
In-Reply-To: <20050302112456.79149.qmail@web51406.mail.yahoo.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