Re: add column sillyness - Mailing list pgsql-general

From Eric Soroos
Subject Re: add column sillyness
Date
Msg-id A28FC81A-2A96-11D8-8708-0003930F2A6C@soroos.net
Whole thread Raw
In response to add column sillyness  (Thomas Zehetbauer <thomasz@hostmaster.org>)
List pgsql-general
>
> 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:

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


pgsql-general by date:

Previous
From: Markus Rebbert
Date:
Subject: Re: dump and sequence initilizing
Next
From: pnl@adslhome.dk
Date:
Subject: Tables and Enheritance