postgres vs mysql performance

by nijave, Sunday, October 28, 2018, 23:43 (143 days ago)

Hi, curious if anyone has compared these to see if there's much difference. My db is currently at 140k items & has 4 cores/4GB of RAM on an SSD but is still a little bit slow (2-3 seconds for feed to load with little PHP CPU usage). There's a few others apps using it but those are fairly idle. Just curious if postgres is any different performance wise

postgres vs mysql performance

by nijave, Thursday, March 07, 2019, 19:19 (13 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)

RSS Feed of thread
powered by my little forum