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

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

2015-05-27 Thread digoal zhou
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 manual one-by-one when has many tables. If we can add syntax for