Re: Postgresql performance and tuning questions

On Thu, 2006-02-16 at 10:39, Tomeh, Husam wrote:
> I do understand your school of thinking. But let me say this, from just
> a user point of view who had used 7.4.x, 8.0, and 8.1, I'd highly
> recommend to start off with 8.1. I can comment on performance in
> particular among other great stuff such as scalability, robustness etc.
> The performance in 8.1 compared with previous releases (even 8.0) is
> remarkable and frankly like the difference between day and light,
> specially when it comes to complex queries in large databases. From a
> technical point of view, you can view the docs to find out more about
> the great improvements with 8.1, such as
> http://www.postgresql.org/docs/whatsnew

And I'd like to add that of all the pieces of software I've ever used,
none has consistently improved in terms of stability, performance, and
features as well as the PostgreSQL project. Not one.

It's the only project I've ever used that every new version has improved
on all three of those areas every single time, and the gotchas from new
versions have been small to non-existent.

In fact, I'd say that bosses who were anti-new software versions have
been far more of a problem than new versions of PostgreSQL has ever
been. :)

And I understand too, the aversion to new versions. I've been bitten by
changes to new versions like php, apache, perl, java, and dozens of
other packages. They are nothing like PostgreSQL.