News for hackers. Stuff that matters.
Re:PostgreSQL vs. MS SQL Server by ben_pr on Thursday April 30, 2015 @08:27AM (#9464595)
After seeing the title I assumed the verdict would be that MS SQL is way better. If I wrote a comparison that's how the result would end up. I've used MS SQL from 1998 and PostgreSQL from 2001 and have found MS SQL much easier to use. Different strokes for different folks I guess.
Re:PostgreSQL vs. MS SQL Server by ExpiredLink on Thursday April 30, 2015 @09:05AM (#9464769)
It's a one-page propaganda site (from someone from Shepperton, GB). I'm a big fan of PostgreSQL but this isn't helpful.
Re:PostgreSQL vs. MS SQL Server by silon3 on Thursday April 30, 2015 @09:01AM (#9464753)
I use MSSQL on a current project and really don't like it's query optimizer. It relies too much on statistics which means that slightly complex queries get random behavior really quickly, especially in the beginning as the database if growing.

IMO, completely unsuitable for web apps where DBA is not sitting around 24/7.

Is PostgreSQL better at this?

Re:PostgreSQL vs. MS SQL Server by atwebb on Thursday April 30, 2015 @09:39AM (#9464950)
How would you suggest optimizing queries except on stats? Do you find instances where the stats are incorrect? If you're trying to do small things in a big table, have you used indexing to help target the small sets/fields you're looking at?
Re:PostgreSQL vs. MS SQL Server by anarazel on Thursday April 30, 2015 @09:15AM (#9464826)
Not really. Postgres' planner is also statistics based. Yes that approach has problems, but the contrary, where you still use a plan that was appropriate for three rows with a couple million isn't good either. It's just a hard problem.