Re: Are Indices automatically generated for primary keys? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Are Indices automatically generated for primary keys?
Date
Msg-id 4C6BA6D5020000250003482D@gw.wicourts.gov
Whole thread Raw
In response to Re: Are Indices automatically generated for primary keys?  (Clemens Eisserer <linuxhippy@gmail.com>)
List pgsql-performance
Clemens Eisserer <linuxhippy@gmail.com> wrote:

> Its quite harsh to imply I didn't look for documentation.

Sorry; I didn't mean to be harsh.  PostgreSQL has excellent
documentation, and we strive to make it better all the time.
Sometimes people coming from some other products aren't used to that
-- I was just trying to point you in the direction of being able to
find things in the future, to save you trouble and delay.

> I looked at the "Indexes and ORDER BY" which doesn't mention it,
> or I've overlook it.
> Doesn't make a difference anyway.

Well, it very much does make a difference, because when someone
makes the effort to find something in our documentation, and in
spite of their best efforts they can't, we tend to consider that a
bug in the documentation.  I'll take a look at the page you
mentioned and see if I can work in a suitable reference.  I'm sure
you can see, though, why the *main* place it was documented was the
statement which is generally used to create a primary key.

Thanks for responding with the info on where you looked.

-Kevin

pgsql-performance by date:

Previous
From: Clemens Eisserer
Date:
Subject: Re: Are Indices automatically generated for primary keys?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Are Indices automatically generated for primary keys?