Re: add column sillyness - Mailing list pgsql-general

From Eric Soroos
Subject Re: add column sillyness
Date
Msg-id 286FC7BD-2A97-11D8-8708-0003930F2A6C@soroos.net
Whole thread Raw
In response to add column sillyness  (Thomas Zehetbauer <thomasz@hostmaster.org>)
Responses Re: add column sillyness
Re: add column sillyness
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: Jan Wieck
Date:
Subject: Re: add column sillyness
Next
From: Alvaro Herrera Munoz
Date:
Subject: Re: add column sillyness