You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by Wes Peng <we...@freenetMail.de> on 2022/04/10 03:15:21 UTC

Re: A simple comparison for three SQL engines

may I forward this report to spark list as well.

Thanks.

Wes Peng wrote:
> Hello,
> 
> This weekend I made a test against a big dataset. spark, drill, mysql, 
> postgresql were involved.
> 
> This is the final report:
> https://blog.cloudcache.net/handles-the-file-larger-than-memory/
> 
> The simple conclusion:
> 1. spark is the fastest for this scale of data and limited memory
> 2. drill is close to spark
> 3. postgresql has surprising behavior in query speed
> 4. mysql is really slow
> 
> If you have found any issue please let me know.
> 
> Thanks
> 
> Wes Peng wrote:
>> sure.I will take time to do it.
>>
>>
>> Sanel Zukan wrote:
>>> Any chance you can try with Postgres >= 12, default configuration with
>>> the same indexed columns as with MySQL?

---------------------------------------------------------------------
To unsubscribe e-mail: user-unsubscribe@spark.apache.org