Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg uses non-unique index instead of pkey index - Mailing list pgsql-general

From Tom Lane
Subject Re: Pg uses non-unique index instead of pkey index
Date
Msg-id 29531.993505278@sss.pgh.pa.us
Whole thread Raw
In response to Pg uses non-unique index instead of pkey index  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
Tree view 
"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:
> Why exactly is experimentsc_expid_i chosen over experimentsc_pkey?

There is no reason to prefer either one over the other.  So you get
a quasi-random choice (whichever one the optimizer happens to consider
first, I think).

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Ploski
Date:
Subject: RE: PostgreSQL: YMMV?
Next
From: Ed Loehr
Date:
Subject: pgsql 7.1.2 server hanging...