postgres vs mysql performance

by nijave, Thursday, March 07, 2019, 19:19 (2236 days ago) @ nijave

I'll go ahead and leave an update. Testing with Selfoss 2.17 using the php:7.1-apache container:

Postgres (postgres:latest):

MySQL (mysql:latest):

So looks like Postgres is a decent deal faster assuming the cache is warm. These were both running in Docker on Windows with no tuning or additional configuration. The database was copied to each instance from my regular one which contains ~150k items.

(Just realized the first one is using Unread instead of Newest but the numbers are the same after changing to the correct filter. Changing MySQL version to Unread filter averages about ~1.7 seconds so slightly higher)