Temporal Gene Expression Analysis Pipeline in PostgreSQL

Design a complex PostgreSQL database schema that can track multi-dimensional gene expression data across different experimental conditions and time points. Create a solution that can handle large-scale RNA sequencing data, including normalized expression values, experimental metadata, sample tracking, and support for temporal analysis. Implement partitioning strategies for performance, develop window functions to calculate fold changes, and create a robust indexing approach that allows for sub-second retrieval of complex genomic queries.