I implemented table partitioning, and it caused havoc with a "select
max(id)" on the parent table - the query plan has changed from a
lightningly fast backwards index scan to a deadly seq scan. Both
partitions are set up with primary key index and draws new IDs from
the same sequence ... "select max(id)" on both partitions are fast.
Are there any tricks I can do to speed up this query? I can't add the
ID to the table constraints, we may still get in "old" data causing
rows with fresh IDs to get into the old table.
(I decided to keep this short rather than include lots of details -
but at least worth mentioning that we're using PG9)