Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.0.2 and 6.5.3 performance - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.0.2 and 6.5.3 performance
Date
Msg-id 178.969046265@sss.pgh.pa.us
Whole thread Raw
In response to 7.0.2 and 6.5.3 performance  (lec <englim@pc.jaring.my>)
List pgsql-general
Tree view 
lec <englim@pc.jaring.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems buidling PostgreSQL v7.0.2 on Solaris 2.5.1
Next
From: "Steve Wolfe"
Date:
Subject: Re: windows UI tool???