Re: Slow index creation

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Paul van der Linden <paul(dot)doskabouter(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow index creation
Date: 2021-02-16 18:44:50
Message-ID: CAHOFxGoDoyQKQDczYWcpAE1rHMSSzp7ZH6PEFwPacXCt0PWVLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is your concern with it taking 20 hours vs 1 hour? Is this index
re-created on a regular basis?

Would it make any sense to materialize the value of foo(a,b,c) as a
generated column (PG12+ natively, or maintained by a trigger before)? Or
even bar(foo(a,b,c),geom)?

Do you know if parallel_workers are being used?

JIT is available in PG11, it is just off by default. If it is available,
turning it on and trying it seems like the simplest check if it would speed
up the index creation.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2021-02-16 18:47:37 How to return a jsonb list of lists (with integers)
Previous Message Peter Coppens 2021-02-16 18:34:32 Re: Order by not working