On Tue, Dec 10, 2019 at 8:25 AM Jeremy Finzel <finz...@gmail.com> wrote:
> Is there a way for me to test this theory? I tried the following with no > change in behavior: > > 1. Disable write load to table > 2. Vacuum analyze table (not vac full) > 3. Create index > 4. 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 :). Thanks, Jeremy
