query-planner

PostgreSQL+table partitioning: inefficient max() and min()

Hi, I have a huge partitioned table stored at a PostgreSQL table. Each child table has an index and a check constraint on its id, e.g. (irrelevant deatils removed for clarity): Master table: points Column | Type | Modifiers ---------------+-----------------------------+----------------------...