Re: Why does everyone think MySQL is easier?
От | Mats Lofkvist |
---|---|
Тема | Re: Why does everyone think MySQL is easier? |
Дата | |
Msg-id | y2qptsp4v8w.fsf@algonet.se обсуждение исходный текст |
Ответ на | Why does everyone think MySQL is easier? ("Nigel J. Andrews" <nandrews@investsystems.co.uk>) |
Ответы |
Re: Why does everyone think MySQL is easier?
|
Список | pgsql-general |
My experience is that the majority of the things considered easier to do in MySQL are just done differently in Postgres and hence makes Postgres look slightly harder to manage to those used to MySQL (and vice versa, but I suspect there are more people with MySQL experience trying out Postgres than the other way around). A few things comes to mind making MySQL somewhat easier though: - it is extremely rare for an upgrade to require dump/restore - you don't have to worry about running vacuum analyze regularly The common dump/restore requirement with Postgres makes it harder to manage an installation (especially with lots of databases) since a software upgrade must be synchronized with a database reload for all databases (*). The need for vacuum makes Postgres work less well straight out of the box, if you don't know about it your performance will slowly go down the drain. (I don't remember how the vacuum improvements in 7.3 change this, will a 7.3 installation work reasonably well without vacuum being run at all e.g. in a scenario with lots of updates? (**)) _ Mats Lofkvist mal@algonet.se (*) A temporary fix to this could be to change the installation to install under a versioned directory (a la gcc) just making the lastest version the default and maybe then change postmaster to start the correct version of the server after checking the database? Even if the latter part is left out, just having the old versions still available by default would improve things imho. And of course postmaster should refuse to start with a version mismatch (at least unless some override flag is used), but maybe this is already the case? (**) If not, the auto-vacuum I have seen discussed will be even more welcome :-)
В списке pgsql-general по дате отправления: