Re: Joining tables by UUID field - very slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cherio <cherio(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Joining tables by UUID field - very slow
Date: 2012-02-27 15:25:31
Message-ID: 13339.1330356331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Cherio <cherio(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Lew 2012-02-27 17:07:04 Re: Very long deletion time on a 200 GB database
Previous Message Shaun Thomas 2012-02-27 15:14:13 Re: Very long deletion time on a 200 GB database