Re: [GENERAL] union all taking years - PG 9.6

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: [GENERAL] union all taking years - PG 9.6
Дата
Msg-id CAHyXU0wYMx7x6M-ki2UQ7hWZ6QBPgZEqFb0z-NwV6_nHf4BMFQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] union all taking years - PG 9.6  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Mon, May 15, 2017 at 6:21 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
> I created a view selecting from both tables, with a UNION ALL between them.
> When selecting from that view, it's really slow. I can't even run explain
> analyze (it's been 1h and query did not finished yet).

Have you ruled out locks? Let the select run and check
pg_stat_activity and pg_locks.   If everything is good there, please
paste contents of explain (without analyze) and explain analyze of the
'good' queries.

merlin

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round4 - compilation issues on RHEL 7.2
Следующее
От: Eric Hill
Дата:
Сообщение: Re: [GENERAL] storing large files in database - performance