FeatureFuel
3

Missing index on `filecache` for `storage` and `path_hash`

Source: nextcloud/server#47901 · opened by @hashworks
⚠️ This issue respects the following points: ⚠️ • This is a bug, not a question or a configuration/webserver/proxy issue. • This issue is not already reported on [Github]( OR [Nextcloud Community Forum]( _(I've searched it)_. • Nextcloud Server is up to date. See [Maintenance and Release Schedule]( for supported versions. • I agree to follow Nextcloud's [Code of Conduct]( Bug description I'm using Nextcloud with PostgreSQL. When I open a folder with many pictures the thumbnail requests kill the server. I tracked this down with slow query log to the following query which is executed for every thumbnail: ![image]( Adding the missing index fixes the issue for me: I don't know if this is an issue with other database systems, but I suspect so. Steps to reproduce 1. Activate query log in your PostgreSQL instance 2. Open a folder with many pictures to request the thumbnails 3. See high system load and the above query in…

No pledges yet. Be the first to back this.

Make a pledge

Pledge your monetary support if this feature is added.

$

Comments

No comments yet.

Replying to

Add a comment

What do you think about this feature request?


Similar requests