|
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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On
Behalf Of akp geek 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 |
