Re: [HACKERS] [COMMITTERS] pgsql: Implement table partitioning.

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: [HACKERS] [COMMITTERS] pgsql: Implement table partitioning.
Дата
Msg-id F0C67105-ADFE-4A47-B461-DC5230D6BE43@thebuild.com
обсуждение исходный текст
Ответ на Re: [HACKERS] [COMMITTERS] pgsql: Implement table partitioning.  (Keith Fiske <keith@omniti.com>)
Ответы Re: [HACKERS] [COMMITTERS] pgsql: Implement table partitioning.
Список pgsql-hackers
> On Dec 9, 2016, at 22:52, Keith Fiske <keith@omniti.com> wrote:
> On Fri, Dec 9, 2016 at 10:01 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> One thing that's tricky/annoying about this is that if you have a
>> DEFAULT partition and then add a partition, you have to scan the
>> DEFAULT partition for data that should be moved to the new partition.
>> That makes what would otherwise be a quick operation slow.  Still, I'm
>> sure there's a market for that feature.
>
> I would find that perfectly acceptable as long as a caveat about the performance impact was included in the
documentation.

+1.  I don't think it's conceptually different from adding a column with a default, in that regard; you just have to
knowthe impact. 


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Effect of caching hash bucket size while costing
Следующее
От: Artur Zakirov
Дата:
Сообщение: Re: [HACKERS] [sqlsmith] Crash in tsquery_rewrite/QTNBinary