Re: [HACKERS] Can we add syntax for references auto create index or not.

2015-05-27 Thread digoal zhou
2015-05-28 1:41 GMT+08:00 David G. Johnston : > On Tue, May 26, 2015 at 7:03 PM, digoal zhou > wrote: > >> When we create table, some column use foreign key references. >> Now PostgreSQL don't create index for the FK, and there is no problem. >> But when some body need the index to speed up the q

Re: [HACKERS] Can we add syntax for references auto create index or not.

2015-05-27 Thread David G. Johnston
On Wednesday, May 27, 2015, digoal zhou wrote: > > 2015-05-28 1:41 GMT+08:00 David G. Johnston >: > >> On Tue, May 26, 2015 at 7:03 PM, digoal zhou > > wrote: >> >>> When we create table, some column use foreign key references. >>> Now PostgreSQL don't create index for the FK, and there is no pro

Re: [HACKERS] Can we add syntax for references auto create index or not.

2015-05-27 Thread David G. Johnston
On Tue, May 26, 2015 at 7:03 PM, digoal zhou wrote: > When we create table, some column use foreign key references. > Now PostgreSQL don't create index for the FK, and there is no problem. > But when some body need the index to speed up the query within these APP, > they need to add the index man