Re: planner/optimizer question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: planner/optimizer question
Дата
Msg-id 17175.1083275671@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
Ответы Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
Список pgsql-performance
"Gary Doades" <gpd@gpdnet.co.uk> writes:
> In this example the statistics don't matter.

Don't they?

A prior poster mentioned that he thought MSSQL tries to keep all its
indexes in memory.  I wonder whether you are giving Postgres a fair
chance to do the same.  What postgresql.conf settings are you using?

            regards, tom lane

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

Предыдущее
От: "Gary Doades"
Дата:
Сообщение: Re: planner/optimizer question
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Simply join in PostrgeSQL takes too long