Re: When to use PARTITION BY HASH?
От
Ron
Тема
Re: When to use PARTITION BY HASH?
Дата
Msg-id
0592c44a-cd2b-da4b-4dea-2017ae41507a@gmail.com
Ответ на
Re: When to use PARTITION BY HASH? (Oleksandr Shulgin)
Список
Дерево обсуждения
When to use PARTITION BY HASH? Oleksandr Shulgin <oleksandr.shulgin@zalando.de>
Re: When to use PARTITION BY HASH? Stephen Frost <sfrost@snowman.net>
Re: When to use PARTITION BY HASH? Oleksandr Shulgin <oleksandr.shulgin@zalando.de>
Re: When to use PARTITION BY HASH? MichaelDBA <MichaelDBA@sqlexec.com>
Re: When to use PARTITION BY HASH? Michel Pelletier <pelletier.michel@gmail.com>
Re: When to use PARTITION BY HASH? Oleksandr Shulgin <oleksandr.shulgin@zalando.de>
Re: When to use PARTITION BY HASH? Michel Pelletier <pelletier.michel@gmail.com>
Re: When to use PARTITION BY HASH? Oleksandr Shulgin <oleksandr.shulgin@zalando.de>
Re: When to use PARTITION BY HASH? Ron <ronljohnsonjr@gmail.com>
Re: When to use PARTITION BY HASH? David Rowley <dgrowleyml@gmail.com>
Re: When to use PARTITION BY HASH? Jeff Janes <jeff.janes@gmail.com>
Re: When to use PARTITION BY HASH? Oleksandr Shulgin <oleksandr.shulgin@zalando.de>
Re: When to use PARTITION BY HASH? Jeff Janes <jeff.janes@gmail.com>
Re: When to use PARTITION BY HASH? Ron <ronljohnsonjr@gmail.com>
Re: When to use PARTITION BY HASH? "David G. Johnston" <david.g.johnston@gmail.com>
On 6/8/20 3:40 AM, Oleksandr Shulgin wrote:
[snip]
How does hashed (meaning "randomly?) distribution of records make partition-wise joins more efficient?
Or -- since I interpret that as having to do with "locality of data" -- am I misunderstanding the meaning of "partition-wise joins"?
[snip]
I've found the original commit adding this feature in version 11: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1aba8e651ac3e37e1d2d875842de1e0ed22a651eIt says:"Hash partitioning is useful when you want to partition a growing data
set evenly. This can be useful to keep table sizes reasonable, which
makes maintenance operations such as VACUUM faster, or to enable
partition-wise join."
How does hashed (meaning "randomly?) distribution of records make partition-wise joins more efficient?
Or -- since I interpret that as having to do with "locality of data" -- am I misunderstanding the meaning of "partition-wise joins"?
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления
