Re: Postgres performance

lists(at)boutiquenumerique(dot)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.