pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
To: pgsql-performance@postgresql.org
Subject: Superior performance in PG 7.4
Date: Wed, 12 Nov 2003 13:41:03 -0200 (BRST)
Message-ID: <2834.192.168.1.120.1068651663.squirrel@webmail.ad2.com.br> (raw)

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




Message-ID: <2834.192.168.1.120.1068651663.squirrel@webmail.ad2.com.br>
Permalink:  ../2834.192.168.1.120.1068651663.squirrel@webmail.ad2.com.br/
Also on:    postgresql.org/message-id/2834.192.168.1.120.1068651663.squirrel@webmail.ad2.com.br

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: alepaes@aldeiadigital.com.br
  Subject: Re: Superior performance in PG 7.4
  In-Reply-To: <2834.192.168.1.120.1068651663.squirrel@webmail.ad2.com.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox