Re: add column sillyness - Mailing list pgsql-general

From Jan Wieck
Subject Re: add column sillyness
Date
Msg-id 3FD642D4.5040006@Yahoo.com
Whole thread Raw
In response to Re: add column sillyness  (Eric Soroos <eric-psql@soroos.net>)
List pgsql-general
Eric Soroos wrote:

>>
>> MySQL is CLEARLY SUPERIOR in terms of
>> - usability
>>   - see above
>> - performance
>>   - uses index for for min()/max()
>> - reliability
>>   - no need to use vacuum
>>   - no need to dump and restore databases for version upgrade
>>   - never screwed up any of my databases
>>
>
> You forgot space saving storage of floating point numbers:

He also forgot that it returns far less error messages since it just
assumes "something" whenever the input is unintelligible or if the
requested feature is not what the programmer should want, speed wise.

Oh, and it is much much faster too. For example numeric data does not
use those horrible expensive string math routines for exact precision,
it has full hardware floating point support instead, so it will actually
use your math co-proc (if you have one). These accounting bureaucrats
really shouldn't worry, at that speed one can create many more results
and one will probably be right someday.


Jan

>
> mysql> create table test(foo int);
> Query OK, 0 rows affected (0.51 sec)
>
> mysql> insert into test (foo) values (1.5);
> Query OK, 1 row affected (0.42 sec)
>
> mysql> select * from test;
> +------+
> | foo  |
> +------+
> |    2 |
> +------+
> 1 row in set (0.01 sec)
>
> eric
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: Alvaro Herrera Munoz
Date:
Subject: Re: add column sillyness
Next
From: Bruce Momjian
Date:
Subject: Re: add column sillyness