Re: [pgsql-advocacy] Has anyone heard of dev01 and their switch fromPG to SQL-Server?

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: [pgsql-advocacy] Has anyone heard of dev01 and their switch fromPG to SQL-Server?
Дата
Msg-id CAKt_ZfsdVh-ZkzMBs5JV8xVE5w1gJv-+rPd1a+Se2fd9K6=+qQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [pgsql-advocacy] Has anyone heard of dev01 and their switch fromPG to SQL-Server?  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-advocacy
Дерево обсуждения


On Thu, Jul 20, 2017 at 9:18 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Thu, Jul 20, 2017 at 8:53 AM, vinny <vinny@xs4all.nl> wrote:
> It sounds more like a microsoft project to prove SQL-Server can be used on
> linux in production,
> than an actual case study. Especially the bit about "an immense reduction in
> database maintenance requirements".
> SQL-Server requiring less maintenance than PostgreSQL? What where they
> doing?
>
> Anyway, it'll be interesting to see how their new setup holds out, maybe we
> can learn something from it.

Without any actual numbers, facts and numbers, it is hard to make an
opinion about something. Especially, there is no way to know if
something wrong has been done with Postgres just by looking at this
post, particularly if there have been misconfigurations. So based only
on this information provided here this is just magic powder in the
eyes.

Additionally there are areas where I would expect SQL Server to in fact require less database maintenance and some areas where it is the clearly correct choice in a given environment.

However....  Unless you have a vast amount of in-house experience with both I seriously doubt that you will see a reduction in database administration load from switching even in those cases.  Now, if your database team are SQL Server gurus who were trying out PostgreSQL, then yeah I could imagine it. 
--
Michael


--
Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

В списке pgsql-advocacy по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [pgsql-advocacy] Has anyone heard of dev01 and their switch fromPG to SQL-Server?
Следующее
От: Josh Berkus
Дата:
Сообщение: [pgsql-advocacy] Correlated columns & firsts