7 ms·
For those stuck on older versions of Postgres, I highly recommend paying the downtime to upgrade. Going from 9.x to 11 will get you a measurably large performan
by rtpg 7y ago
For those stuck on older versions of Postgres, I highly recommend paying the downtime to upgrade. Going from 9.x to 11 will get you a measurably large performance gain for free.
- dspillett 7y agoOut of interest (SQL Server guy mainly, so only partly keep up with what other engines are doing), what changes significantly affect performance (without making changes to your own code/configuration to make use of new features) in 10.x & 11.x?
- greggyb 7y agoBig parallelism updates that the query planner can take advantage of. I believe also updates to index seek or scan in that time.
- fabian2k 7y agoThere is usually a bunch of small improvements in every release, and those can add up over time. In Postgres 10 and 11 a lot of stuff happened related to parallel queries, and many more queries can be run in parallel now. 11 added a JIT compiler to the query planner, but I'm not sure whether that is enabled by default yet.
- cldellow 7y agoThe query planner in 10 got a lot better at enforcing row-level security constraints efficiently for some common scenarios, like 10-20x speedups. See https://github.com/postgres/postgres/commit/215b43cdc8d6b4a1700886a39df1ee735cb0274d https://github.com/postgres/postgres/commit/215b43cdc8d6b4a1... and the linked mailing list thread for more info, if you're curious.
- Scarbutt 7y agoOut of interest ;) SQL Server is such an expensive beast, ~$15K per core, what are your reasons for prefering it over PG?
- sovnade 7y agoIt's about $7000 per core for enterprise - and if you do something like license a whole blade and put VMs on top of it, you could fairly easily run 10-20+ SQL VMs on one decent sized blade for < 150k. And anything pre-prod is free. It's a small cost for most larger size companies of this scale. If you have one or two servers, then no, enterprise is probably out of reach.
- eropple 7y agoI quite like Postgres and use it preferentially, but your numbers are off. SQL Server Enterprise costs more like $7500/core; that $15K pack, as far as I am aware, comes with two core licenses. SQL Server Standard 2016 costs $931 for a license if you use CALs ($209 a pop), or $3700/core. Also bear in mind that almost nobody pays list price for any of this.
- Keyframe 7y ago$7500 per core, but only $15,000 for two cores sounds like a sweet deal though.
- grouseway 7y agoThere are no more server CPUs with less than 6 cores though. We could happily manage with just 2 dedicated to SQL server, but you have to license all the cores you have. So 3K worth of low end hardware ends up costing you several multiples of that in licensing.
- ape4 7y agoIt kinda bugs me that people say "SQL Server" to mean "Microsoft SQL Server". I mean, there are other sql servers.
- giovannibonetti 7y agoGood to know! Can you give an example? When I google "SQL Server" it seems like most results are related to MS SQL Server
- BubRoss 7y agoAn example of other SQL servers? PostgreSQL would be one, which is what this thread is about.
- dragonwriter 7y ago> It kinda bugs me that people say "SQL Server" to mean "Microsoft SQL Server". I mean there are other sql servers. I don't mind that; sure, there are other RDBMS servers that support SQL as their main or exclusive language, but unless you are talking about ancient Sybase products (for which there is a very good reason for the shared branding) “SQL Server” is a clear, exclusive Microsoft product identity and not any worse of a label, say, FTP (yes, there are other file transfer protocols). OTOH,what does bug me is when people say “SQL” to mean “Microsoft SQL Server”.
- buster 7y agohttps://en.wikipedia.org/wiki/SQL_Server https://en.wikipedia.org/wiki/SQL_Server Same as "FTP Server" doesn't mean proftpd, "HTTP Server" doesn't mean apache and "C compiler" doesn't mean gcc. SQL is a language. Server is a generic term. Another example: I may ask my colleague the following: "Which SQL server should we use in our new project?". Does this mean, i would like to know the edition and version of the MS SQL Server or maybe (and from my point of view more likely) i am looking for PostgreSQL, MySQL or MSSQL. If i'd like to know which edition and version i should use, i'd ask "Which MS SQL Server should i use?". That's a difference. Might be that our views differ but i can understand the parents points.
- SEJeff 7y agoOne of the huge ones was the ability to use > 1 cpu core for big aggregations or huge select queries. That and a massively better query planner.
- barrkel 7y agoI've just upgraded my hobby app from 9.6 to 11 and some of my old queries are now timing out :-| I'll update this thread when I find out why.