Re: When to use PARTITION BY HASH?

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 6/5/20 8:51 AM, Jeff Janes wrote:

On Fri, Jun 5, 2020 at 6:12 AM Oleksandr Shulgin <oleksandr.shulgin@xxxxxxxxxx> wrote:

    [snip]

For a bulk load you'd likely want to go with an empty partition w/o indexes and build them later, after loading the tuples. 

That only works if the bulk load is starting from zero.  If you are adding a million rows to something that already has 100 million, you would probably spend more time rebuilding the indexes than you saved by dropping them.

    It's too bad that Postgres doesn't have "deferred index updates"
    during bulk (but still transactional) loads, where the index nodes
    are updated en masse every "commit count" number of rows. 
    That's really useful in this situation, but I've only seen
    it in one legacy RDBMS.

--
Angular momentum makes the world go 'round.