Re: Joining tables by UUID field - very slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Joining tables by UUID field - very slow
Дата
Msg-id 13339.1330356331@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Joining tables by UUID field - very slow  (Cherio <cherio@gmail.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Shaun Thomas
Дата:
Сообщение: Re: Very long deletion time on a 200 GB database
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Very long deletion time on a 200 GB database