Cherio writes:
> This statement takes over 6 times longer than a similar statement against
> the same table except the join is done by a integer field, e.g.
Could we see EXPLAIN ANALYZE data for both cases?
How are you representing the UUIDs, exactly (ie what's the column data
type)?
On Fri, Feb 24, 2012 at 4:46 PM, Cherio wrote:
> We are experiencing an unusual slowdown when using UUID field in JOIN when
> updating a table. SQL looks like this:
>
> UPDATE dst
> SET data_field = src.data_field
> FROM src
> WHERE dst.uuid_field = src.uuid_field;
>
> This statement takes over 6
We are experiencing an unusual slowdown when using UUID field in JOIN when
updating a table. SQL looks like this:
UPDATE dst
SET data_field = src.data_field
FROM src
WHERE dst.uuid_field = src.uuid_field;
This statement takes over 6 times longer than a similar statement against
the same table exc
