Yes, the slow query is the a join operation of table topic and topic_user_ids. When user has created a lot of topics before, the operation of show latest page will be slow. I will try to tune it by using better PostgresSQL and work_mem and shared_buffers. Thanks @mpalmer nd @Falco
SimonWu
(Simon Wu)
6
関連トピック
| トピック | 返信 | 表示 | アクティビティ | |
|---|---|---|---|---|
| Long loading times for user summary page with slow database | 17 | 2147 | 2019 年 10 月 29 日 | |
| Slow Profile Loads with 100GB+ database | 42 | 3590 | 2020 年 12 月 29 日 | |
| PostgreSQL runaway IO | 35 | 3711 | 2021 年 3 月 3 日 | |
| Slow performance due to per query latency connecting to database? | 8 | 987 | 2018 年 9 月 11 日 | |
| Slow SQL query causes homepage to load in 2-4 sec | 15 | 1836 | 2018 年 2 月 7 日 |