Postgres Pro
Downloads
Home   >   mailing lists

Re: Joining tables by UUID field - very slow - Mailing list pgsql-performance

From Tom Lane
Subject Re: Joining tables by UUID field - very slow
Date
Msg-id 13339.1330356331@sss.pgh.pa.us
Whole thread Raw
In response to Joining tables by UUID field - very slow  (Cherio <cherio@gmail.com>)
List pgsql-performance
Tree view 
Cherio <cherio@gmail.com> 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

pgsql-performance by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Very long deletion time on a 200 GB database
Next
From: Claudio Freire
Date:
Subject: Re: Very long deletion time on a 200 GB database