Re: index scan of whole table, can't see why

Поиск
Список
Период
Сортировка
От andrew@pillette.com
Тема Re: index scan of whole table, can't see why
Дата
Msg-id 200501200500.j0K50W508121@pillette.com
обсуждение исходный текст
Ответ на index scan of whole table, can't see why  ("Dan Langille" <dan@langille.org>)
Ответы Re: index scan of whole table, can't see why  (Ragnar Hafstað <gnari@simnet.is>)
Список pgsql-performance
This is a multi-part message in MIME format.

--bound1106197232
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Let's see if I have been paying enough attention to the SQL gurus. The planner is making a different estimate of how
manydeprecated<>'' versus how many broken <> ''. I would try SET STATISTICS to a larger number on the ports table, and
re-analyze.

--bound1106197232--

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

Предыдущее
От: Gustavo Franklin Nóbrega
Дата:
Сообщение: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)
Следующее
От: William Yu
Дата:
Сообщение: Re: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)