Re: Are Indices automatically generated for primary keys?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Are Indices automatically generated for primary keys?
Дата
Msg-id 20100818135456.GA17355@depesz.com
обсуждение исходный текст
Ответ на Are Indices automatically generated for primary keys?  (Clemens Eisserer <linuxhippy@gmail.com>)
Список pgsql-performance
On Wed, Aug 18, 2010 at 03:51:22PM +0200, Clemens Eisserer wrote:
> Hi,
>
> Are indices for columns marked with "PRIMARY KEY" automatically generated by
> postgresql, or do I have to do it manually?
> The question might seem dumb, I ask because I remember from working with
> MySQL it generates indices automatically in this case.

they are generated automatically.

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

В списке pgsql-performance по дате отправления:

Предыдущее
От: Clemens Eisserer
Дата:
Сообщение: Are Indices automatically generated for primary keys?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Are Indices automatically generated for primary keys?