Re: how to speed up query - Mailing list pgsql-general

From Andrus
Subject Re: how to speed up query
Date
Msg-id f4mi6m$1buq$1@news.hub.org
Whole thread Raw
In response to Re: how to speed up query  (Erwin Brandstetter <brsaweda@gmail.com>)
List 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.


pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: how to speed up query
Next
From: "Andrus"
Date:
Subject: Re: how to speed up query