Problem description

I have what could be considered a large podcast collection; over 100 podcasts. with the latest edge builds, it can take over 115 seconds to load the podcasts page.

Steps to reproduce

subscribe to a lot of big podcasts?

System information

11.0.0-SNAPSHOT.20220320083637 in a k8s environment with NFS storage

Additional notes

adding two indexes reduces the time to around 18 seconds.
create index idx_podcast_channel_id on podcast_episode using btree ( channel_id );
create index idx_podcast_episode_guid on podcast_episode using btree ( episode_guid );