Re: Creating Empty Index - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Creating Empty Index
Date
Msg-id CAB7nPqQpV1km2tU03ZyQzWiEVzmo3UQnEbC0-PcjE0_uJefoEg@mail.gmail.com
Whole thread Raw
In response to Re: Creating Empty Index  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Creating Empty Index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, Nov 2, 2013 at 10:28 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
> What exactly would be the point? Indexes are automatically maintained by
> postgres. Something that isn't doesn't seem to me to qualify for the
> description of "index".
Perhaps an index without data that could be used by the planner for
automatic query tuning to evaluate how a query could run if the index
exists? Like the concept of hypothetical indexes or something like the
possibility to do a CREATE/ALTER INDEX ... WITH [ NO ] DATA.
-- 
Michael



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Creating Empty Index
Next
From: Kevin Grittner
Date:
Subject: Re: [GENERAL] Cannot create matview when referencing another not-populated-yet matview in subquery