[GENERAL] Postgres 8.2.3 or 8.1.8?

2007-03-29 Thread Qiao Yang
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,

[GENERAL] MAX() across partition tables

2006-06-13 Thread Qiao Yang
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