Re: postgresql 8.0 advantages - Mailing list pgsql-general

From Julian Scarfe
Subject Re: postgresql 8.0 advantages
Date
Msg-id 029a01c51cbb$3ed844b0$0600a8c0@Wilbur
Whole thread Raw
In response to postgresql 8.0 advantages  (Si Chen <schen@graciousstyle.com>)
List pgsql-general
From: "Tom Lane" <tgl@sss.pgh.pa.us>

> There are some speed improvements in 8.0 too, though that wasn't the
> main focus of the release cycle.  For instance, Lonni Friedman's nearby
> thread reports on a case where 8.0 consistently finds a much better
> query plan for a complex query than prior releases did, because we fixed
> some issues in the GEQO planner module.

Could you give an example or two of the sorts of queries for which
performance is improved under 8.0 compared with 7.4, please Tom?

Thanks

Julian Scarfe



pgsql-general by date:

Previous
From: Mike Rylander
Date:
Subject: Re: Backupping the table values
Next
From: Christopher Browne
Date:
Subject: Re: postgresql 8.0 advantages