Cherio <cherio@xxxxxxxxx> 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)? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance