| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: union all taking years - PG 9.6 |
| Date: | 2017-05-18 14:52:39 |
| Message-ID: | CAHyXU0wYMx7x6M-ki2UQ7hWZ6QBPgZEqFb0z-NwV6_nHf4BMFQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, May 15, 2017 at 6:21 PM, Patrick B <patrickbakerbr(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Hill | 2017-05-18 15:00:49 | Re: storing large files in database - performance |
| Previous Message | Adrian Klaver | 2017-05-18 14:20:08 | Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2 |