On Tue, Dec 10, 2019 at 8:25 AM Jeremy Finzel <finzelj@gmail.com> wrote:
Is there a way for me to test this theory? I tried the following with no change in behavior:
Disable write load to table
Vacuum analyze table (not vac full)
Create index
Explain
Still did not pick up the index.
Just another followup: with no other intervention on our part, after many hours the planner is picking up the index.
I don't quite know what is causing it still, but is this behavior actually desired? It's pretty inconvenient when trying to build an index for a query need and immediately use it which used to work :).