From: akp geek [mailto:akpg...@gmail.com]
Sent: Thursday, January 07, 2010 9:04 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Index question on postgres
{snip}
Why would the index I have created not being used?
>>
The index you have created will not be u
OK.. got you.
Regards
On Fri, Jan 8, 2010 at 2:37 PM, Vick Khera wrote:
> there ya go. the query plan will change based on the data statistics
> on the tables and indexes.
>
> On Fri, Jan 8, 2010 at 2:09 PM, akp geek wrote:
> > The volume of data is less in Test compared to prod. and I synced
there ya go. the query plan will change based on the data statistics
on the tables and indexes.
On Fri, Jan 8, 2010 at 2:09 PM, akp geek wrote:
> The volume of data is less in Test compared to prod. and I synced the
> postgresql.conf file in both environments
--
Sent via pgsql-general mailing
The volume of data is less in Test compared to prod. and I synced the
postgresql.conf file in both environments
Regards
On Fri, Jan 8, 2010 at 1:55 PM, Vick Khera wrote:
> On Thu, Jan 7, 2010 at 11:11 PM, akp geek wrote:
> > I have query in production and test. The tables in both the environme
On Thu, Jan 7, 2010 at 11:11 PM, akp geek wrote:
> 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 tim
On Thu, Jan 7, 2010 at 10:04 PM, akp geek wrote:
> the explain from both enviroments ??? need to be posted.
> just one quick question. Why would the index I have created not being used?
> Regards
Better explain analyze than plain eplain.
If the retrieval of data by seq scan is deemed "cheaper" th
; *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 P
Post the results here
From: akp geek [mailto:akpg...@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
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@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 -
>
>
>
&
On Thu, Jan 7, 2010 at 9:11 PM, akp geek wrote:
> 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
-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
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 no
12 matches
Mail list logo
