Re: benchmarks

>  Comparing PostgreSQL to MySQL is  like comparing an 18-wheel Kenworth to
> a Porsche. The two are not equivalent
That's it. Major differences in features makes any benchmarking `apples to
oranges.'

> ... if you want a simple, very
> very fast READ-ONLY database, use MySQL.
BTW, can it  be used on a  r/o partition, or it still  writes something to
the files (locks, stats)?

>  If you want a full-featured transaction-environment database for a huge,
> complex set of data, use PostgreSQL.
Even if the  system is relatively small and simple....  Everything will go
down in fires, this is the law. So,  the first thing to think about is what
will  your options  be when  you're trying  to keep  the parts.  Stress and
torture tests would be more usefull than benchmarking.

>  Any benchmarks  you find are  likely comapring  the two for  hosting web
> sites, which is unfair to PostgreSQL.
IIRC,  there was  one  in favor  PGSQL  (wasn't it  run  by the  Bridge?).
However, the very  fact of benchmarking these two  along with non-disclosed
commercial products, where  PGSQL wins with flying colours,  IMHO does more
harm than good.

> If everything your database needs
> to do is serve up page content, go for MySQL.
How 'bout flat files? They will be even faster. Main advantage of DBMS, as
I  see  it, is  a  possibility  to  build searchable,  logically  connected
structures, with consistency and concurrency  supported on the server side.
With MySQL  one has neither  referential integrity, nor server  side logic.
Moreof, HTML pages are bad as  textual attributes even when tuple/page size
limitation can be easily worked around.If you  want dynamic  content, SSI  and CGI will  do, and  there's nothing
about DBMS. Storing page templates as BLOBs gives nothing but slowdown.

>  If  you've  got   to  build  a  60-user   inventory  management  system,
> MySQL  won't  even  bring you  close  -  heck,  it's  not even  close  to
> SQL92-compliant.
It's still  possible, one  can even  get it for  $ 200,  but TCO  will sky
rocket when it starts to phreak, or when business rules will be changed.


--
contaminated fish and microchips huge supertankers on Arabian tripsoily propaganda from the leaders' lips all about the
futurethere'speople over here, people over there everybody's looking for a little more aircrossing all the borders just
totake their share planning for the future
 
Rainbow, Difficult to Cure