Re: 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
>