Continuing the discussion from Improve performance of Topic load - ORDER BY RANDOM : The added index is great, but it excludes PMs :sadpanda:. Since we have suggested topics on the PM page (since when?) the performance vary a lot (sub second to 30 secods) on this query (on a dedicated PostgreSQL 9…

Aha yes good catch – @sam we should extend the index.

It’s a completely different query though, agree it needs to be optimised but not sure that index will sort it. In particular, “suggested” searches for stuff you have access to by joining multiple tables. Also searches for previous messages with overlap of participants It is complicated work

Created the following index: CREATE INDEX index_private_message_topics_on_created_at_and_visible ON topics USING btree (created_at, visible) WHERE deleted_at IS NULL AND archetype::text = 'private_message'::text; And it indeed doesn’t work :sadpanda:. If I get something that works I will …

Sam, It looks like the query is only slow for me! It’s because the “Welcome to Discourse” messages came from my user, so 30% (112.000) of the rows from topic_users are on my user_id. For other users, the query is crazy fast! And after trying many indexes and query modifications it’s really trick…

Private Message Page Performance

Development

tgxworld (Alan Tan) 9월 13, 2017, 2:30오후 6

I got some nice improvement out of this

https://github.com/discourse/discourse/commit/28148197d6467cdc7469409f961c00d4e32f4c41

글		댓글	조회수
Slow loading on private-message-topic-tracking-state.json Bug	32	2249	10월 4, 2021
Improve performance of Topic load - ORDER BY RANDOM Bug slow-sql	22	4644	3월 1, 2015
Slow Page Loads on User Profiles Feature	14	2722	11월 23, 2020
Slow Profile Loads with 100GB+ database Feature	42	3579	12월 29, 2020
SQL query to get the queue of all the PMs in the system Product Support	2	2100	1월 27, 2016

Private Message Page Performance

Related topics