We have a read-only replica of our main PostgreSQL database being used by our data analytics team.
They would like to create indexes on the read replica to improve performance of analytics queries, without affecting the main database.
I've found that this is possible for MySQL RDS instances. However, for PostgreSQL this indicates it's not possible:
Each PostgreSQL read replicas is read-only. You can't make a writable read replica.
Is there any way to create an index on a read-only replica in PostgreSQL? If not, is there some workaround for this problem?