From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: Postgres performance
Date: Thu, 03 Mar 2005 12:39:13 -0500
Message-ID: <60fyzciq7y.fsf@dba2.int.libertyrms.com> (raw)
References: <d64dda1e.0502230229.3deaf864@posting.google.com>
<421D8ABC.2030601@archonet.com>
<d64dda1e.0503010252.67c2312d@posting.google.com>
<1109775613.30529.359.camel@state.g2switchworks.com>
<opsm05ecu9th1vuj@musicbox>
lists@boutiquenumerique.com (PFC) writes:
>> The reason PostgreSQL is slower is because it (and by extension the team
>> behind it) cares about your data.
>
> Sure, postgres is (a bit but not much) slower for a simple
> query like SELECT * FROM one table WHERE id=some number, and
> postgres is a lot slower for UPDATES (although I heard that it's
> faster than MySQL InnoDB)...
There is a _HUGE_ set of misconceptions here.
1. The speed difference is only repeatedly true for simple selects
when done against MyISAM tables.
2. That speed difference for UPDATEs is only true if you are talking
about ONE MySQL(tm) client doing updates against MyISAM tables.
MyISAM does not support row locks; if multiple clients are
trying to update a table, they must fight for a single table
lock, with the result that updating tables doesn't scale _at
all_ with MySQL(tm) for the default table type.
If you only have one process touching the database, MySQL(tm) can
therefore look quite a lot better than PostgreSQL. Move to 2 clients
and it's not quite so good. Move to 100 concurrent clients all trying
to do updates and you may discover that you simply can't do that...
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/linuxxian.html
A VAX is virtually a computer, but not quite.
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: cbbrowne@acm.org
Subject: Re: Postgres performance
In-Reply-To: <60fyzciq7y.fsf@dba2.int.libertyrms.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