Re: Join optimization for inheritance tables

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Join optimization for inheritance tables
Дата
Msg-id 4ABFBD3F.3010204@agliodbs.com
обсуждение исходный текст
Ответ на Re: Join optimization for inheritance tables  (Emmanuel Cecchet <manu@asterdata.com>)
Список pgsql-hackers
On 9/26/09 3:00 PM, Emmanuel Cecchet wrote:
> Hi Simon,
> 
> Thanks for the insight. I might take that as a long term project. I have
> to discuss that with my colleagues at Aster. It would certainly help to
> put together a wiki page with the key insights on the design of such
> implementation to be able to better scope the project and agree on what
> is the right approach for this.

In the meantime, can you look at the possibility I suggested?  If you
could produce a patch which would implement the most common and least
complex case of partition joining: where the constraints on two
partitions match exactly (or are mathematically provable subsets) with a
small patch, it would probably work for 8.5.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pg_hba.conf: samehost and samenet [REVIEW]
Следующее
От: Stef Walter
Дата:
Сообщение: Re: pg_hba.conf: samehost and samenet [REVIEW]