Has anyone heard of dev01 and their switch from PG to SQL-Server?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Has anyone heard of dev01 and their switch from PG to SQL-Server?

Joshua Kramer-3
Hello All-

dev01 is a company that is profiled in some Microsoft materials as
they recently implemented SQL-Server 2017 on Linux.  According to some
materials on their site, they switched from Postgres/Redshift to
SQL-Server and saw immediate performance improvements.  Of course,
it's short on details...

https://www.dv01.co/dv01s-technology-featured-by-microsoft-at-data-amp-event-profiled-in-case-study/


--
Sent via pgsql-advocacy mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Reply | Threaded
Open this post in threaded view
|

Re: Has anyone heard of dev01 and their switch from PG to SQL-Server?

Josh Berkus-6
On 07/19/2017 10:50 AM, Joshua Kramer wrote:
> Hello All-
>
> dev01 is a company that is profiled in some Microsoft materials as
> they recently implemented SQL-Server 2017 on Linux.  According to some
> materials on their site, they switched from Postgres/Redshift to
> SQL-Server and saw immediate performance improvements.  Of course,
> it's short on details...
>
> https://www.dv01.co/dv01s-technology-featured-by-microsoft-at-data-amp-event-profiled-in-case-study/

Well, presumably if they hadn't seen performance improvements, they
wouldn't have switched.  Survivor bias and all that.


--
Josh Berkus
Containers & Databases Oh My!


--
Sent via pgsql-advocacy mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Reply | Threaded
Open this post in threaded view
|

Re: Has anyone heard of dev01 and their switch from PG to SQL-Server?

Marcin Cieslak
On Wed, 19 Jul 2017, Josh Berkus wrote:

> On 07/19/2017 10:50 AM, Joshua Kramer wrote:
> > Hello All-
> >
> > dev01 is a company that is profiled in some Microsoft materials as
> > they recently implemented SQL-Server 2017 on Linux.  According to some
> > materials on their site, they switched from Postgres/Redshift to
> > SQL-Server and saw immediate performance improvements.  Of course,
> > it's short on details...
> >
> > https://www.dv01.co/dv01s-technology-featured-by-microsoft-at-data-amp-event-profiled-in-case-study/
>
> Well, presumably if they hadn't seen performance improvements, they
> wouldn't have switched.  Survivor bias and all that.
Their app frontend (40.79.47.136) seems to be hosted on Azure.

Looking at this

https://techcrunch.com/2017/07/17/how-microsoft-brought-sql-server-to-linux/

they barely got their "platform abstraction" thing working. I've seen the Platform
Abstraction Layer of .NET Core (the small, multiplatform .NET engine) and it's
a hack. Everything is bent to match 1990-era Win32 APIs.

Anyone to ask them directly? I think this should be explained quickly.

Marcin Cieślak

smime.p7s (4K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Has anyone heard of dev01 and their switch from PG to SQL-Server?

Michael Paquier
In reply to this post by Josh Berkus-6
On Thu, Jul 20, 2017 at 8:53 AM, vinny <[hidden email]> 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.
--
Michael


--
Sent via pgsql-advocacy mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Reply | Threaded
Open this post in threaded view
|

Re: Has anyone heard of dev01 and their switch from PG to SQL-Server?

Chris Travers-5


On Thu, Jul 20, 2017 at 9:18 AM, Michael Paquier <[hidden email]> wrote:
On Thu, Jul 20, 2017 at 8:53 AM, vinny <[hidden email]> 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 ([hidden email])
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.