At 07:21 06/01/12, Michael Fuhr wrote:
>On Wed, Jan 11, 2006 at 02:38:42PM -0800, Burak Seydioglu wrote:
> > I do a load of sql joins using primary and foreign keys. What i would like
> > to know if PostgreSQL creates indexes on these columns automatically (in
> > addition to using them to maintain referential integrity) or do I have to
> > create an index manually on these columns as indicated below?
> > CREATE TABLE cities (
> > city_id integer primary key,
> > city_name varchar(50)
> > );
> > CREATE INDEX city_id_index ON cities(city_id);
>PostgreSQL automatically creates indexes on primary keys. If you run
>the above CREATE TABLE statement in psql you should see a message to
>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
>"cities_pkey" for table "cities"
Is there a way to suppress this notice when I create tables in a script?
In response to
pgsql-performance by date
|Next:||From: Mark Liberman||Date: 2006-01-12 00:41:20|
|Subject: Stable function being evaluated more than once in a single query|
|Previous:||From: Jamal Ghaffour||Date: 2006-01-12 00:32:10|
|Subject: Please Help: PostgreSQL performance Optimization|