Re: [SQL] sql performance and cache

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [SQL] sql performance and cache
Дата
Msg-id 3F87E8E5.1000203@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [SQL] sql performance and cache  ("Chris Faulkner" <chrisf@oramap.com>)
Список pgsql-performance
>  Nested Loop  (cost=0.00..147.11 rows=1 width=148) (actual
> time=84.00..12323.00 rows=67 loops=1)

The planner estimate doesn't seem to match reality in that particular
step.  Are you sure you've run:

ANALYZE oscar_node;
ANALYZE oscar_point;

And you could even run VACUUM FULL on them just to make sure.

Does that make any difference?

Chris



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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [SQL] sql performance and cache
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: [SQL] sql performance and cache