Princi Vershwal

SLO-106 Added index on status field for posts table

4

There are slow queries on the posts table that take up to 5 minutes to browse posts for customers with a large number of posts. Sentry link: https://ghost-foundation.sentry.io/performance/?isDefaultQuery=false&metricSearchSetting=metricsOnly&project=1879038&query=transaction%3A%22GET+%2Fghost%2Fapi%2Fadmin%2Fposts%2F%22&statsPeriod=7d&utc=true There are...

Added created_at index to the members_click_events table

1

Ref https://linear.app/tryghost/issue/ONC-216/improve-the-performance-of-the-membersevents-aggregated-click-event

Ref SLO-188

High water mark test

1

> [!NOTE] > Add comprehensive timing and progress logging to S3 storage uploads, including multipart, with chunk-sized stream reads. > > - **Backend (storage)**: > - **Instrumentation**: Add detailed timing/progress...