Re: Index question on postgres

the explain from both enviroments ??? need to be posted.

just one quick question. Why would the index I have created not being used?

Regards

On Thu, Jan 7, 2010 at 11:34 PM, Dann Corbit <DCorbit(at)connx(dot)com> wrote:

> Post the results here
>
>
>
> *From:* akp geek [mailto:akpgeek(at)gmail(dot)com]
> *Sent:* Thursday, January 07, 2010 8:30 PM
> *To:* Dann Corbit
> *Cc:* pgsql-general(at)postgresql(dot)org
> *Subject:* Re: [GENERAL] Index question on postgres
>
>
>
> I did that and the Explain look different
>
>
>
> Regards
>
>
>
> On Thu, Jan 7, 2010 at 11:13 PM, Dann Corbit <DCorbit(at)connx(dot)com> wrote:
>
> If you do a:
>
> VACUUM FULL ANALYZE
>
> for both production and for test and then do an EXPLAIN on your queries,
> what do the plans look like?
>
>
>
> *From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *akp geek
> *Sent:* Thursday, January 07, 2010 8:11 PM
> *To:* pgsql-general(at)postgresql(dot)org
> *Subject:* [GENERAL] Index question on postgres
>
>
>
> Hi All -
>
>
>
> I have query in production and test. The tables in both the
> environment has the same structure ,indexes and constraints. But the in the
> test and the prod the explain plan is totally different. In test environment
> the query is taking long time and noticed that indexes are not being
> utilized ? I am not able to figure it Can you please share your thoughts?
>
>
>
>
>
> Regards
>
>
>