PostgreSQL 生成列与表达式索引实践

PostgreSQL 生成列与表达式索引实践ALTER TABLE orders ADD COLUMN total NUMERIC GENERATED ALWAYS AS (price * quantity) STORED;

CREATE INDEX idx_orders_total ON orders (total);

CREATE INDEX idx_users_lower_name ON users ((lower(name)));

EXPLAIN SELECT * FROM users WHERE lower(name) = 'alice';

总结生成列适合可派生的稳定表达式，表达式索引可优化函数条件查询，二者结合提升整体性能。