Re: Problem with planner choosing nested loop

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Problem with planner choosing nested loop
Дата
Msg-id dcc563d10804021127ie4c4e1br90f9c6722da4ae1b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem with planner choosing nested loop  ("Rodrigo E. De León Plicet" <rdeleonp@gmail.com>)
Список pgsql-general
On Wed, Apr 2, 2008 at 12:12 PM, Rodrigo E. De León Plicet
<rdeleonp@gmail.com> wrote:
> Also important, consider creating additional indexes based on your
>  access patterns.

Good point.  Note that you can create indexes and then track their
usefulness with the pg_stat_user_indexes view, which I find incredibly
useful.  In fact, all the pg_stat_ views are useful.

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

Предыдущее
От: Alex Solovey
Дата:
Сообщение: Re: Problem with planner choosing nested loop
Следующее
От: "Morris Goldstein"
Дата:
Сообщение: Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?