Create Virtual Indexes on Postgres

From: Sreerama Manoj <manoj(dot)sreerama973(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Create Virtual Indexes on Postgres
Date: 2015-02-26 06:47:37
Message-ID: CA+go1QGDi_QH4wdij8kGeAqzosPOSftCM=nCQuwgTVQm_w80gQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I use Postgres 9.4 database.Now,I am optimizing the queries by using
the results of "explain" and "explain analyze",Sometimes I am creating
Indexes to optimize them. But, I was not successful sometimes as even I
create Index to optimize them, the planner is not using them .

So my question was can we know whether the planner will use the index
before actually creating a real Index..or can we create "virtual" or
"Hypothetical" Index those can only be known to the planner and not the
user or Is there any alternative to do it..If present,share with me.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Sewell 2015-02-26 07:34:34 Composite index and min()
Previous Message Sergey Shchukin 2015-02-26 06:25:31 Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary