Re: How to create virtual indexes on postgres

<div dir="ltr">But, it runs with  Postgres 9.1 version...But I use 9.4..I think I cant use that. Or as an alternative
Isthere any provision in postgres to know use(Increase in Performance) of an index before creating that
index.</div><divclass="gmail_extra"><br /><div class="gmail_quote">On Thu, Feb 26, 2015 at 5:37 PM, Michael Paquier
<spandir="ltr"><<a href="mailto:michael.paquier@gmail.com" target="_blank">michael.paquier@gmail.com</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class="">OnThu, Feb 26, 2015 at 6:20 PM, Sreerama Manoj<br /> <<a
href="mailto:manoj.sreerama973@gmail.com">manoj.sreerama973@gmail.com</a>>wrote:<br /> > So my question was can
weknow whether the planner  will use the index<br /> > before actually creating a real Index..or can we create
"virtual"or<br /> > "Hypothetical" Index those can only be known to the planner and not the user<br /> > or Is
thereany alternative to do it..If present,share with me.<br /><br /></span>No, the index needs to be created to allow
theplanner to use it. This<br /> reminds me of this project though, that if I recall correctly has<br /> patches
Postgresto allow the use of hypothetical indexes:<br /><a href="https://sourceforge.net/projects/hypotheticalind/"
target="_blank">https://sourceforge.net/projects/hypotheticalind/</a><br/><span class="HOEnZb"><font
color="#888888">--<br/> Michael<br /></font></span></blockquote></div><br /></div>