Re: how to speed up query

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to speed up query
Date: 2007-06-12 16:36:11
Message-ID: f4mi6m$1buq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> Theis is also primary key constraint in dok table:
>>
>> CONSTRAINT dok_pkey PRIMARY KEY (dokumnr),
>
>
> On a sidenote: this primary implements a unique index anyway. The
> additional index is useless. You can delete it to save time and
> storage.
> (Or maybe this is just another discrepancy between reality and problem
> description.)

Erwin,

thank you.
This index was duplicated.
I changed my script not to create this index.
However this should not affect to speed a much since this index is created
after data is loaded to table.

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2007-06-12 16:38:01 Re: how to speed up query
Previous Message Tom Lane 2007-06-12 16:26:35 Re: INSERT ... RETURNING in v8.2