Ghost Release: 5.64.0

TL;DR

Ghost v5.64.0 Release

This release focuses on significant performance improvements for the Collections feature in Ghost. The main highlight is the optimization of collection repository queries, which dramatically reduces overhead when dealing with large datasets. The update also includes a data repopulation for built-in collections to ensure proper functionality after previous feature flag changes.

These optimizations are particularly important for sites with large numbers of collection posts, where query performance has been improved by nearly 9x in testing scenarios. The changes maintain full functionality while making the system much more efficient.

Highlight of the Release

• Optimized collection repository queries with up to 9x performance improvement
• Reduced memory usage when fetching collections data
• Repopulated collections_posts data for built-in collections
• Fixed stale data issues in collections_posts table

Migration Guide

No specific migration steps are required for this update. The release includes an automatic migration that will repopulate the collections_posts data for built-in collections.

When upgrading:

1. Follow the standard Ghost update procedure
2. The system will automatically run the migration to fix collections data
3. No manual intervention is required

Upgrade Recommendations

This release is recommended for all users, especially those who:

• Use the Collections feature in Ghost
• Have sites with large numbers of posts and collections
• Have experienced performance issues with collections

The performance improvements are substantial and will benefit all Ghost installations, with the most noticeable impact on larger sites. There are no breaking changes, making this a safe upgrade with minimal risk.

Bug Fixes

Collections Data Repopulation

Fixed an issue where the collections_posts data had gone stale after previous feature flag changes. This release includes a migration that:

• Clears the data in the collections_posts table
• Repopulates it properly using the same approach as the initial migration from v5.5
• Ensures built-in collections function correctly again

This addresses the issue tracked in TryGhost/Arch#74.

New Features

No new features were introduced in this release. The focus was on performance optimizations and bug fixes for the existing Collections functionality.

Security Updates

No security fixes were included in this release.

Performance Improvements

Collection Repository Query Optimization

This release significantly improves the performance of collection repository queries:

• Eliminated the overhead of creating Bookshelf models for each collection_post relation
• Optimized memory usage by querying only post IDs by default instead of full post data
• Testing with large datasets showed dramatic performance improvements:
  • Before: ~7 seconds to process 500k collections_posts records
  • After: ~810ms for the same dataset (nearly 9x faster)

These optimizations are particularly beneficial for sites with large numbers of posts and collections, reducing both processing time and memory consumption.

The improvements were implemented as part of TryGhost/Arch#86.

Impact Summary

This release delivers significant performance optimizations for the Collections feature in Ghost, dramatically improving query efficiency and reducing memory usage. The changes address a specific performance bottleneck in collection repository queries, resulting in up to 9x faster processing for large datasets.

Additionally, the release fixes an issue with stale data in the collections_posts table that occurred after previous feature flag changes. The included migration ensures that built-in collections function correctly again by repopulating the necessary data.

These improvements maintain full backward compatibility while making the system much more efficient, particularly for sites with large numbers of posts and collections. Users will experience faster loading times and better responsiveness when working with collections in the admin interface, with no action required to benefit from these enhancements.

Full Release Notes