MySQL vs PostgreSQL关注w/ GIS和速度。

时间:2021-09-04 14:26:15

I'm aware there are a few threads out there addressing this issue, but I'm wondering if anything has changed since those have been published.

我知道有一些线程在解决这个问题,但是我想知道自从这些已经发布之后,是否有什么变化。

I'm looking to build a GIS webapp, and people are all saying that PostgreSQL is the way to go because it supports various things that have to do with mapping better, whereas MySQL's spatial extensions aren't too great.

我想构建一个GIS webapp,人们都说PostgreSQL是一种可行的方式,因为它支持各种各样与映射更好的事情,而MySQL的空间扩展并不太好。

So PostgreSQL seems like the way to go, but everywhere I go I'm reading that PostgreSQL is terribly slow compared to MySQL, is this still true?

所以PostgreSQL似乎是可行的,但无论我走到哪里,我都读到PostgreSQL与MySQL相比非常慢,这还是正确的吗?

If I want to use GeoDjango with MySQL, will I be able to do most everything?

如果我想使用GeoDjango和MySQL,我能做大部分的事情吗?

I'm really stuck between the two, simply because people keep saying PostgreSQL is really slow, but MySQL isn't really great for dealing with GIS stuff.

我在这两者之间卡住了,因为人们一直说PostgreSQL很慢,但是MySQL对于处理GIS的东西不是很好。

What's your take SO?

你这么是什么?

4 个解决方案

#1


7  

No, postgresql is not slower. This myth is due to people running single threaded sequential benchmarks on myisam vs postgresql. Benchmarks that attempt to model actual usage conditions with many concurrent queries put postgresql on par with or ahead of mysql in performance, especially as you scale up in CPUs/cores.

不,postgresql并不慢。这个误解是由于人们在myisam和postgresql上运行单线程的顺序基准测试。尝试用许多并发查询为实际使用条件建模的基准测试,在性能上,尤其是在cpu /内核中扩展时,可以将postgresql与mysql的性能相匹配。

http://www.randombugs.com/linux/mysql-postgresql-benchmarks.html

http://www.randombugs.com/linux/mysql-postgresql-benchmarks.html

http://tweakers.net/reviews/657/5

http://tweakers.net/reviews/657/5

#2


6  

Check this topic: GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?

查看这个主题:GIS: PostGIS/PostgreSQL和MySql vs. SQL Server?

PostGIS is much more mature and complete, and competes with Oracle and SQL Server, not MySQL. Sorry.

PostGIS更加成熟和完善,与Oracle和SQL Server竞争,而不是MySQL。对不起。

#3


5  

In my opinion, it's silly to compare MySQL and PostgreSQL in terms of speed if there are variables unknown, such as - what's your budget, what's your target system output and what's your load rate?

在我看来,比较MySQL和PostgreSQL的速度是很傻的,如果有未知的变量,比如,你的预算是多少,你的目标系统输出是多少,你的负载率是多少?

Both RDBMSs are great, and they can be scaled. The difference is that MySQL has pluggable engine architecture, allowing it to plug in various engines. Natively, MySQL supports 9 engines if I'm not mistaken but it has a plethora of commercial engines to choose from, along with 2 popular forks (Percona's and MariaDB) that introduce various enhancements, especially for InnoDB storage engine.

两个rdbms都很好,它们可以被扩展。不同的是,MySQL有可插拔的引擎架构,允许它插入各种引擎。本机,MySQL支持9个引擎,如果我没有错,但是它有太多的商业引擎可供选择,还有2个流行的分支(Percona和MariaDB),它们引入了各种增强,特别是对于InnoDB的存储引擎。

Real question is, what does it mean that something is "bad" at GIS "stuff"? What does bad mean? Can't calculate something? Can't store something? I just don't get what you consider bad really.

真正的问题是,在地理信息系统的“东西”中,什么东西是“坏的”?坏是什么意思?不能计算吗?不能存储吗?我就是不明白你到底是怎么想的。

I doubt you can go wrong by choosing either of the two databases, just beware of false benchmarks claiming one product is faster than another. Set your goal in terms of performance, install both products on your test machine and run them. If both satisfy your performance needs, use the one you feel more comfortable developing with.

我怀疑你选择这两个数据库中的任何一个都可能出错,只是小心错误的基准,声称一个产品比另一个更快。在性能方面设定目标,在测试机器上安装两个产品并运行它们。如果两者都满足您的性能需求,使用您觉得更舒适的开发。

#4


3  

When it comes to GIS capabilities, have a look at this GIS SE question:

当谈到GIS能力时,看看这个地理信息系统的问题:

Would PostGIS offer an advantage over MySQL for a produce farm application?

PostGIS是否比MySQL更适合农产品的应用?

I think that from all that I read here and on GIS SE site, PostgreSQL with PostGIS is a clear winner when it comes to handling spatial data.

我认为,从我在这里读到的和在GIS SE网站上所看到的,在处理空间数据方面,PostGIS的PostgreSQL是一个明显的赢家。

#1


7  

No, postgresql is not slower. This myth is due to people running single threaded sequential benchmarks on myisam vs postgresql. Benchmarks that attempt to model actual usage conditions with many concurrent queries put postgresql on par with or ahead of mysql in performance, especially as you scale up in CPUs/cores.

不,postgresql并不慢。这个误解是由于人们在myisam和postgresql上运行单线程的顺序基准测试。尝试用许多并发查询为实际使用条件建模的基准测试,在性能上,尤其是在cpu /内核中扩展时,可以将postgresql与mysql的性能相匹配。

http://www.randombugs.com/linux/mysql-postgresql-benchmarks.html

http://www.randombugs.com/linux/mysql-postgresql-benchmarks.html

http://tweakers.net/reviews/657/5

http://tweakers.net/reviews/657/5

#2


6  

Check this topic: GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?

查看这个主题:GIS: PostGIS/PostgreSQL和MySql vs. SQL Server?

PostGIS is much more mature and complete, and competes with Oracle and SQL Server, not MySQL. Sorry.

PostGIS更加成熟和完善,与Oracle和SQL Server竞争,而不是MySQL。对不起。

#3


5  

In my opinion, it's silly to compare MySQL and PostgreSQL in terms of speed if there are variables unknown, such as - what's your budget, what's your target system output and what's your load rate?

在我看来,比较MySQL和PostgreSQL的速度是很傻的,如果有未知的变量,比如,你的预算是多少,你的目标系统输出是多少,你的负载率是多少?

Both RDBMSs are great, and they can be scaled. The difference is that MySQL has pluggable engine architecture, allowing it to plug in various engines. Natively, MySQL supports 9 engines if I'm not mistaken but it has a plethora of commercial engines to choose from, along with 2 popular forks (Percona's and MariaDB) that introduce various enhancements, especially for InnoDB storage engine.

两个rdbms都很好,它们可以被扩展。不同的是,MySQL有可插拔的引擎架构,允许它插入各种引擎。本机,MySQL支持9个引擎,如果我没有错,但是它有太多的商业引擎可供选择,还有2个流行的分支(Percona和MariaDB),它们引入了各种增强,特别是对于InnoDB的存储引擎。

Real question is, what does it mean that something is "bad" at GIS "stuff"? What does bad mean? Can't calculate something? Can't store something? I just don't get what you consider bad really.

真正的问题是,在地理信息系统的“东西”中,什么东西是“坏的”?坏是什么意思?不能计算吗?不能存储吗?我就是不明白你到底是怎么想的。

I doubt you can go wrong by choosing either of the two databases, just beware of false benchmarks claiming one product is faster than another. Set your goal in terms of performance, install both products on your test machine and run them. If both satisfy your performance needs, use the one you feel more comfortable developing with.

我怀疑你选择这两个数据库中的任何一个都可能出错,只是小心错误的基准,声称一个产品比另一个更快。在性能方面设定目标,在测试机器上安装两个产品并运行它们。如果两者都满足您的性能需求,使用您觉得更舒适的开发。

#4


3  

When it comes to GIS capabilities, have a look at this GIS SE question:

当谈到GIS能力时,看看这个地理信息系统的问题:

Would PostGIS offer an advantage over MySQL for a produce farm application?

PostGIS是否比MySQL更适合农产品的应用?

I think that from all that I read here and on GIS SE site, PostgreSQL with PostGIS is a clear winner when it comes to handling spatial data.

我认为,从我在这里读到的和在GIS SE网站上所看到的,在处理空间数据方面,PostGIS的PostgreSQL是一个明显的赢家。