On 2/26/15 6:17 AM, Sreerama Manoj wrote:
But, it runs with Postgres 9.1 version...But I use 9.4..I think I cant
use that. Or as an alternative Is there any provision in postgres to
know use(Increase in Performance) of an index before creating that index.
No. It might not be too hard to port t
But, it runs with Postgres 9.1 version...But I use 9.4..I think I cant use
that. Or as an alternative Is there any provision in postgres to know
use(Increase in Performance) of an index before creating that index.
On Thu, Feb 26, 2015 at 5:37 PM, Michael Paquier
wrote:
> On Thu, Feb 26, 2015 at
On Thu, Feb 26, 2015 at 6:20 PM, Sreerama Manoj
wrote:
> 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 al
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
