On Mon, May 15, 2017 at 6:21 PM, Patrick B 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 se
On Mon, May 15, 2017 at 4:21 PM, Patrick B wrote:
> Hi guys.
>
> I have two tables, where 'tableA' is the old and 'tableC' is the new one.
> I say "new/old" because we are migrating the data from tableA to tableC
> soon.
>
> I created a view selecting from both tables, with a UNION ALL between
>
On 05/15/2017 04:21 PM, Patrick B wrote:
Hi guys.
I have two tables, where 'tableA' is the old and 'tableC' is the new
one. I say "new/old" because we are migrating the data from tableA to
tableC soon.
I created a view selecting from both tables, with a UNION ALL between
them. When selectin
