Re: wildcard makes seq scan on prod db but not in test

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: wildcard makes seq scan on prod db but not in test
Дата
Msg-id 2757.1304966916@sss.pgh.pa.us
обсуждение исходный текст
Ответ на wildcard makes seq scan on prod db but not in test  (Marcus Engene <mengpg2@engene.se>)
Список pgsql-performance
Дерево обсуждения 
Marcus Engene <mengpg2@engene.se> writes:
> There are about 2M rows on bonddump and 4M rows on bond90.
> bonddump is on a 8MB RAM machine, bond90 is on a 72MB RAM machine.
> The table is analyzed properly both places.

I'll bet one database was initialized in C locale and the other not.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Marcus Engene
Дата:
Сообщение: wildcard makes seq scan on prod db but not in test
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: wildcard makes seq scan on prod db but not in test