Re: Postgres performance

This sort of discussion should really go onto -performance, but I'm
at pains to stomp out a common misperception.

On Wed, Mar 02, 2005 at 10:45:38PM +0100, PFC wrote:
>
> Sure, postgres is (a bit but not much) slower for a simple
> query like SELECT * FROM one table WHERE id=some number, and

This is true _only if_ nobody else is writing at the same time you
are. That is, for single-user or read-only databases, MySQL appears
to have a really significant advantage when using the standard MyISAM
table type. The problem with that table type is that it requires the
_whole table_ be locked during write operations.

In any case, for any sort of real database work, nobody sane would
use anything except the InnoDB table type. That's a more reasonable
fruit-comparison than MySQL using MyISAM. In the latter case, you
may as well compare PostgreSQL to flat file writing.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton