Postgres Pro
Downloads
Home   >   mailing lists

Re: Index question on postgres - Mailing list pgsql-general

From Dann Corbit
Subject Re: Index question on postgres
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547029626E0@postal.corporate.connx.com
Whole thread Raw
In response to Re: Index question on postgres  (akp geek <akpgeek@gmail.com>)
Responses Re: Index question on postgres
List pgsql-general
Tree view

Post the results here

 

From: akp geek [mailto:akpgeek@gmail.com]
Sent: Thursday, January 07, 2010 8:30 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.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@connx.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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of akp geek
Sent: Thursday, January 07, 2010 8:11 PM
To: pgsql-general@postgresql.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

 

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: Index question on postgres
Next
From: akp geek
Date:
Subject: Re: Index question on postgres