Re: [PATCHES] Partition: use triggers instead of rules

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: [PATCHES] Partition: use triggers instead of rules
Дата
Msg-id 474EE25E.3080304@commandprompt.com
обсуждение исходный текст
Ответ на Partition: use triggers instead of rules  (David Fetter <david@fetter.org>)
Ответы Re: [PATCHES] Partition: use triggers instead of rules  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
Michael Paesold wrote:
> NikhilS wrote:

>> <note><para>If you have a partitioning setup that uses rules please
>> refer to the 8.2 documentation on partitioning</para></note>
>>
>> +1
>
> I would also add another sentence about *why* the recommendation was
> changed. We have one rule-based setup here, and it has been working
> flawlessly for us,... so personally I don't even know the reasons.
>

Rules are extremely slow in comparisons and not anywhere near as
flexible. As I said up post yesterday... they work well in the basic
partitioning configuration but anything else they are extremely deficient.

Joshua D. Drake

> Best Regards
> Michael Paesold
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [PATCHES] Partition: use triggers instead of rules
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Partition: use triggers instead of rules