Re: postgresql 8.0 advantages

From: "Julian Scarfe" <julian(at)avbrief(dot)com>
To: "postgresql-general mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql 8.0 advantages
Date: 2005-02-27 10:58:16
Message-ID: 029a01c51cbb$3ed844b0$0600a8c0@Wilbur
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Christopher Browne 2005-02-27 12:19:18 Re: postgresql 8.0 advantages
Previous Message Christopher Browne 2005-02-27 02:12:54 Re: postgresql 8.0 advantages

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2005-02-27 12:19:18 Re: postgresql 8.0 advantages
Previous Message Sven Willenberger 2005-02-27 04:50:57 Re: basic trigger using OLD not working?