Hi,
We plan to upgrade our database from 7.4.11 to 8.x. It seems that both 8.1
and 8.2 branches are maintained. Which one is more stable? 8.1.18 or 8.2.3?
8.1 or 8.2 branch in general?
We are trying to settle with one so we don't have to upgrade for a while.
Thank you in advance for your answers,
Hi,
In Postgres 8.1, MAX() was rewritten to use index backward search without
doing seq_scan. This achieves a huge performance gain. But I found that when
I use MAX() on a partitioned table, it reverses back to the old seq_scan
plan. Wouldn't it be more efficient to get MAX() from each partition t