What happened?
Description
In our test environments with nightly builds, the resourcepaths table grows significantly (>6.5 million rows). It appears to be a path cache for assets; the assets are regenerated each night. We haven’t found a way to delete it via the CLI or console.
Can the table be safely truncated (it’s not included in the backup)? Is there a way to do this via the CLI or console?
Craft CMS version
4.13.10
PHP version
8.2
Operating system and version
Linux Container
Database type and version
Postgreql 15.10
Image driver and version
No response
Installed plugins and versions
What happened?
Description
In our test environments with nightly builds, the resourcepaths table grows significantly (>6.5 million rows). It appears to be a path cache for assets; the assets are regenerated each night. We haven’t found a way to delete it via the CLI or console.
Can the table be safely truncated (it’s not included in the backup)? Is there a way to do this via the CLI or console?
Craft CMS version
4.13.10
PHP version
8.2
Operating system and version
Linux Container
Database type and version
Postgreql 15.10
Image driver and version
No response
Installed plugins and versions