| From: | "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Superior performance in PG 7.4 |
| Date: | 2003-11-12 15:41:03 |
| Message-ID: | 2834.192.168.1.120.1068651663.squirrel@webmail.ad2.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
I am trying the PG 7.4 RC1 and RC2 and I see a superb performance
improvement compared with 7.3....
Explaining the querys, I see a change of planner that, in my case,
prefer Nested Loops in 7.4 opposite to Hash or Merge Join in 7.3.
To test, I disable Hash and Merge Joins in 7.3 and performance
have been very improved using nested loops...
Both systems are identical in configurations, properly vacuuned and
analyzed before tests.
Something can be wrong with my tests ? [ I desire that not :) ]
Alexandre
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-11-12 15:53:56 | Re: Value of Quad vs. Dual Processor machine |
| Previous Message | Rajesh Kumar Mallah | 2003-11-12 15:04:53 | Re: Suggestions for benchmarking 7.4RC2 against 7.3 |