On Mon, May 15, 2017 at 6:21 PM, Patrick B <patrickbake...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
