Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] union all taking years - PG 9.6 - Mailing list pgsql-general

From Merlin Moncure
Subject Re: [GENERAL] union all taking years - PG 9.6
Date
Msg-id CAHyXU0wYMx7x6M-ki2UQ7hWZ6QBPgZEqFb0z-NwV6_nHf4BMFQ@mail.gmail.com
Whole thread Raw
In response to [GENERAL] union all taking years - PG 9.6  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round4 - compilation issues on RHEL 7.2
Next
From: Eric Hill
Date:
Subject: Re: [GENERAL] storing large files in database - performance