[rt-users] Performance problem with SG-clusteren and postgres 8.0.7

[Tomas Olaj]

On the marvelous Mon, 10 Apr 2006, Ruslan Zakirov wrote kindly to me ...

> This is one of the most problematic query in RT. I only can confirm
> that the first plan (on Pg 7.x) is almost optimal one (there is still
> way to optimize it with planner) and this is plan we wanted to achive
> when were changing this query in RT-3.4.5.
>
> I hope Pg 8.1.4 would be available soon and we could recommend that
> instead of Pg 8.0.x.

http://archives.postgresql.org/pgsql-performance/2006-02/msg00089.php

A proposal from the PostgreSQL developers how this SQL can be improved.

Tomas

-- 
________________________________________________________________________
Tomas A. P. Olaj, email: tomas.olaj at usit.uio.no, web: folk.uio.no/tomaso
  University of Oslo / USIT (Center for Information Technology Services)
    System- and Application Management / Applications Management Group