Re: [PERFORM] Avoiding tuple construction/deconstruction during joining

Поиск
Список
Период
Сортировка
От PFC
Тема Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
Дата
Msg-id opsnovnhx0th1vuj@localhost
обсуждение исходный текст
Ответ на Avoiding tuple construction/deconstruction during joining  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
    I have asked him for the data and played with his queries, and obtained
massive speedups with the following queries :

http://boutiquenumerique.com/pf/miroslav/query.sql
http://boutiquenumerique.com/pf/miroslav/query2.sql
http://boutiquenumerique.com/pf/miroslav/materialize.sql

    Note that my optimized version of the Big Joins is not much faster that
the materialized view without index (hash joins are damn fast in postgres)
but of course using an index...

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Real-Time Vacuum Possibility
Следующее
От: PFC
Дата:
Сообщение: Re: [PERFORM] Avoiding tuple construction/deconstruction during joining