Postgres Pro
Downloads
Home   >   mailing lists

Re: Is a better way to have the same result of this query? - Mailing list pgsql-performance

From Jochem van Dieten
Subject Re: Is a better way to have the same result of this query?
Date
Msg-id 3DEFBFBB.1060601@oli.tudelft.nl
Whole thread Raw
In response to Re: Is a better way to have the same result of this query?  (Vernon Wu <vernonw@gatewaytech.com>)
Responses Re: Is a better way to have the same result of this query?
List pgsql-performance
Tree view 
Vernon Wu wrote:
>
> The followings are the analyise outcomes after I did some modifications with the query. My finding is that the new
query 
> does improve the performance according to the plan. The actual time is reversed might due to the fact the test data
is 
> very small (the machine is a very old one by the way). The userid is the key for all tables and the gender is
indexed.Do I  
> also index the country and province to improve the preformance?

You start by using a dataset of realistic size. Sorry, but if the actual
time is < 10.00 ms it is rather pointless to optimize further since
chance is going to be the biggest factor. And the IN/EXISTS difference
is dependent on dataset size.

Jochem

pgsql-performance by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Is a better way to have the same result of this
Next
From: Tomasz Myrta
Date:
Subject: Re: Is a better way to have the same result of this