From: Daniel Henrique Alves Lima <email_daniel_h@yahoo.com.br>
To: Iain <iain@mst.co.jp>
Cc: pgsql-sql@postgresql.org
Subject: Re: Simple SQL question
Date: Tue, 09 Mar 2004 02:43:56 -0300
Message-ID: <404D599C.80101@yahoo.com.br> (raw)
In-Reply-To: <00cd01c40597$58d3e9a0$7201a8c0@mst1x5r347kymb>
References: <404C7EE3.8010006@yahoo.com.br>
<20040308184440.GG588@64.81.242.180>
<404D4667.10206@yahoo.com.br>
<00cd01c40597$58d3e9a0$7201a8c0@mst1x5r347kymb>
Ok, Iain. Thanks for the tip !
Iain wrote:
>Just a note based on my experience, if you are going to to use IN processing
>then there is a good chance that the index isn't going to be used. In some
>recent tests I did, the index stopped being used after I put 3 or more items
>in the IN list. You should build some representatve examples of the select
>and test them using "ANALYSE SELECT ..." .I'm using 7.4.1.
>
>The result from the select is the same, even if you don't make an index on
>the function result.It's just a performance consideration. If the index
>isn't used, then you don't need to create it.
>
>regards
>Iain
>----- Original Message -----
>From: "Daniel Henrique Alves Lima" <email_daniel_h@yahoo.com.br>
>To: <pgsql-sql@postgresql.org>
>Sent: Tuesday, March 09, 2004 1:21 PM
>Subject: Re: [SQL] Simple SQL question
>
>
>
>
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-sql@postgresql.org
Cc: email_daniel_h@yahoo.com.br, iain@mst.co.jp
Subject: Re: Simple SQL question
In-Reply-To: <404D599C.80101@yahoo.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