Re: [HACKERS] Creating Empty Index

2013-11-03 Thread Michael Paquier
On Sun, Nov 3, 2013 at 3:01 AM, Tom Lane wrote: > Michael Paquier writes: >> On Sat, Nov 2, 2013 at 10:28 PM, Andrew Dunstan 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 >>> descriptio

Re: [HACKERS] Creating Empty Index

2013-11-02 Thread Tom Lane
Michael Paquier writes: > On Sat, Nov 2, 2013 at 10:28 PM, Andrew Dunstan 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 cou

Re: [HACKERS] Creating Empty Index

2013-11-02 Thread Michael Paquier
On Sat, Nov 2, 2013 at 10:28 PM, Andrew Dunstan 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 aut

Re: [HACKERS] Creating Empty Index

2013-11-02 Thread Andrew Dunstan
On 11/01/2013 02:11 AM, naman.iitb wrote: Hello Is there a way by which we can create an empty index on a relation and later fill it manually by inserting tuples. I want to know how it can be done in Postgresql code. Thanks in advance What exactly would be the point? Indexes are automatic