Re: Index question on postgres
| От | akp geek |
|---|---|
| Тема | Re: Index question on postgres |
| Дата | |
| Msg-id | 2024a9fb1001081109x4cd5a63di45c4e42f4c45f1b@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Index question on postgres (Vick Khera <vivek@khera.org>) |
| Ответы |
Re: Index question on postgres
|
| Список | pgsql-general |
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 <vivek@khera.org> wrote:
Is the same amount of data in both? Are the other configs of theOn Thu, Jan 7, 2010 at 11:11 PM, akp geek <akpgeek@gmail.com> 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 time and noticed that indexes are not being utilized ? I am not
> able to figure it Can you please share your thoughts?
server the same?
В списке pgsql-general по дате отправления: