Re: Bug #474: Index using problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #474: Index using problem
Date
Msg-id 24148.1002319268@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug #474: Index using problem  (Andreas Wernitznig <andreas@insilico.com>)
Responses Re: Bug #474: Index using problem  (Andreas Wernitznig <andreas@insilico.com>)
List pgsql-bugs
Andreas Wernitznig <andreas@insilico.com> writes:
> Why don't you skip the automatic index creation for primary keys

And how then would we enforce uniqueness of the primary key?

> and let the user decide to create an index, that should be used in any
> case, regardless what the query planner recommends ?

What?  AFAIR the planner does not even *know* whether an index is
associated with a primary key.  It certainly does not give such an
index any special preference.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andreas Wernitznig
Date:
Subject: Re: Bug #474: Index using problem
Next
From: Andreas Wernitznig
Date:
Subject: Re: Bug #474: Index using problem