Re: Updates, deletes and inserts are very slow. What can I do make them bearable?

Tim Uckun <timuckun(at)gmail(dot)com> writes:
> I have a very simple update query.

> update cu
> set screenshot_file_name = tu.screenshot_file_name,
> screenshot_content_type = tu.screenshot_content_type,
> screenshot_file_size = tu.screenshot_file_size,
> screenshot_status = tu.screenshot_status
> from cu
> inner join tu on tu.cu_id = cu.id

That isn't actually the query you're issuing, because if it were
you would get an error "table name "cu" specified more than once".

I suspect that the query you're actually issuing involves an
unconstrained cartesian product self-join between the target table
and another instance of itself. Postgres doesn't consider that
the target table should be named again in FROM. But it's hard to
be sure about that when looking at a redacted query.

regards, tom lane