Re: how to speed up query

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: how to speed up query
Дата
Msg-id f4mi6m$1buq$1@news.hub.org
обсуждение исходный текст
Ответ на Re: how to speed up query  (Erwin Brandstetter <brsaweda@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Andrus"
Дата:
Сообщение: Re: how to speed up query
Следующее
От: "Andrus"
Дата:
Сообщение: Re: how to speed up query