Re: Lifecycle of PostgreSQL releases

> I also tend to run every other version.  I've run 7.2, then 7.4, then
> 8.1.  I've tested and played with 8.2 and speed wise, it wasn't a
> compelling enough upgrade to start the very long process of replacing
> 8.1 with.  By the time 8.3 comes out, I'll be about ready to start
> evaluating our next version of pgsql.
>
> I have to say the update to 8.1 was very compelling, as the query
> optimizer was much better, and the ability to use indexes on date
> columns with references like now() - interval '5 days' was a huge thing
> for my reporting apps.

Yeah 8.1 was a great milestone, being able to allocate more
shared_buffers has been a great boon for many of our customers that are
running 4+ GIG of ram.

Joshua D. Drake




--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend