feat: Implement performance optimizations for database queries

Commit notes

- Added GIN index for full-text search on the samples table and created a generated column for search vector. - Introduced partitioning for the analytics_events table to enhance performance, including a function for automatic partition creation. - Created additional indexes for improved query performance on samples and sample packs. - Added fix scripts for handling partially applied migrations related to these changes.