Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT

Поиск
Список
Период
Сортировка
От Mladen Gogala
Тема Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT
Дата
Msg-id 4CFACC81.3050901@vmsinfo.com
обсуждение исходный текст
Ответ на Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT  (Jochen Erwied <jochen@pgsql-performance.erwied.eu>)
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT  (John Papandriopoulos <dr.jpap@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Tom Lane wrote:
>     Partitioning using these techniques will work well with up to
>     perhaps a hundred partitions; don't try to use many thousands of
>     partitions.
>
>             regards, tom lane
>
Hmmm, what happens if I need 10 years of data, in monthly partitions? It
would be 120 partitions. Can you please elaborate on that limitation?
Any plans on lifting that restriction?

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT
Следующее
От: Jochen Erwied
Дата:
Сообщение: Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT