Complex Customer Segmentation with Recursive Window Functions

Design a recursive SQL query that performs multi-dimensional customer segmentation using advanced window functions in PostgreSQL 13+. The segmentation should incorporate at least 5 behavioral metrics including total purchase value, frequency, recency, product diversity, and customer lifetime value. Implement a hierarchical scoring mechanism that dynamically ranks customers across different segments, with the ability to handle rapidly changing datasets of over 1 million records efficiently.