PostgreSQL 与 InnoDB 的存储路径
假设有一张再普通不过的订单表:主键是 id,用户经常按 status 查询,后台又不断更新订单状态。CREATE TABLE orders ( id bigint PRIMARY KEY, status varchar(32) NOT NULL, buyer_id bigint NOT NULL, total decimal(12, 2) NOT NULL, note varchar(500), created_at timestamp NOT NULL);CREATE INDEX orders_status_i…


