Re: Slow index creation - Mailing list pgsql-general

From Michael Lewis
Subject Re: Slow index creation
Date
Msg-id CAHOFxGoDoyQKQDczYWcpAE1rHMSSzp7ZH6PEFwPacXCt0PWVLA@mail.gmail.com
Whole thread Raw
In response to Slow index creation  (Paul van der Linden <paul.doskabouter@gmail.com>)
Responses Re: Slow index creation  (Paul van der Linden <paul.doskabouter@gmail.com>)
List 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.

pgsql-general by date:

Previous
From: Peter Coppens
Date:
Subject: Re: Order by not working
Next
From: Alexander Farber
Date:
Subject: How to return a jsonb list of lists (with integers)