Re: [HACKERS] [POC] hash partitioning

Поиск
Список
Период
Сортировка
Искать
От
David Steele
Тема
Re: [HACKERS] [POC] hash partitioning
Дата
Msg-id
8e66f899-a264-6e90-82d0-3865178b1e18@pgmasters.net
Ответ на
Список
Дерево обсуждения
Re: [HACKERS] [POC] hash partitioning "yangjie@highgo.com" <yangjie@highgo.com>
Re: [HACKERS] [POC] hash partitioning Yugo Nagata <nagata@sraoss.co.jp>
Re: [HACKERS] [POC] hash partitioning yangjie <yangjie@highgo.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning Thom Brown <thom@linux.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] [POC] hash partitioning Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Andres Freund <andres@anarazel.de>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Andres Freund <andres@anarazel.de>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Andres Freund <andres@anarazel.de>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Andres Freund <andres@anarazel.de>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] [POC] hash partitioning Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] [POC] hash partitioning Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning amul sul <sulamul@gmail.com>
Re: [HACKERS] [POC] hash partitioning David Fetter <david@fetter.org>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] [POC] hash partitioning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [POC] hash partitioning Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
On 3/3/17 8:33 AM, amul sul wrote:
> On Fri, Mar 3, 2017 at 5:00 PM, Greg Stark  
>     It also has the advantage that it's easier to see how to add more
>     partitions. You just split all the ranges and (and migrate the
>     data...). There's even the possibility of having uneven partitions if
>     you have a data distribution skew -- which can happen even if you have
>     a good hash function. In a degenerate case you could have a partition
>     for a single hash of a particularly common value then a reasonable
>     number of partitions for the remaining hash ranges.
> 
> Initially
> ​we
>  had
> ​to have ​
> somewhat similar thought to make a range of hash
> values for
> ​ ​
> each partition, using the same half-open interval syntax we use in general:
> 

<...>

> So it's pretty
> ​ ​
> user-unfriendly.

This patch is marked as POC and after a read-through I agree that's
exactly what it is.  As such, I'm not sure it belongs in the last
commitfest.  Furthermore, there has not been any activity or a new patch
in a while and we are halfway through the CF.

Please post an explanation for the delay and a schedule for the new
patch.  If no patch or explanation is posted by 2017-03-17 AoE I will
mark this submission "Returned with Feedback".

-- 
-David
david@pgmasters.net


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Gather Merge
От: David Steele
Дата:
FAQ