Re: Actual rows significantly more than estimated during many joins

Поиск
Список
Период
Сортировка
От Andrew Beverley
Тема Re: Actual rows significantly more than estimated during many joins
Дата
Msg-id 20160604131858.74ce49cb6698475f9984b771@andybev.com
обсуждение исходный текст
Ответ на Actual rows significantly more than estimated during many joins  (Andrew Beverley <andy@andybev.com>)
Список pgsql-general
Дерево обсуждения 
On Sat, 4 Jun 2016 Andrew Beverley <andy@andybev.com> wrote:
> When I run EXPLAIN ANALYZE, I see that the actual query is scanning
> significantly more rows for the join than was estimated. There is also
> a huge number of loops for the joins. Why is this, and is there an
> easy fix?

I should have said: PostgreSQL version 9.4.6 running on Debian 8.4

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

Предыдущее
От: Andrew Beverley
Дата:
Сообщение: Actual rows significantly more than estimated during many joins
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: Replication