Re: 7.0.2 and 6.5.3 performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lec <englim(at)pc(dot)jaring(dot)my>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.0.2 and 6.5.3 performance
Date: 2000-09-15 19:31:05
Message-ID: 178.969046265@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

lec <englim(at)pc(dot)jaring(dot)my> writes:
> Under 7.0.2, there are no Hash Join or Hash

So, then, what *does* it do? Without the explain for 7.0.2 it's
impossible to tell what's happening.

> Are there any way to optimize this type of query?

Um, have you vacuum analyzed the tables involved?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2000-09-15 20:05:46 Re: windows UI tool???
Previous Message Tom Lane 2000-09-15 19:26:57 Re: Problems buidling PostgreSQL v7.0.2 on Solaris 2.5.1