Re: 8.x index insert performance

Поиск
Список
Период
Сортировка
От Kelly Burkhart
Тема Re: 8.x index insert performance
Дата
Msg-id 1130781106.7026.46.camel@krb06.tradebot.com
обсуждение исходный текст
Ответ на Re: 8.x index insert performance  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список pgsql-performance
On Mon, 2005-10-31 at 12:32 -0500, Merlin Moncure wrote:
> well, can you defer index generation until after loading the set (or use
> COPY?)

I cannot defer index generation.

We are using the copy API.  Copying 10000 rows in a batch.

>
> if that index is causing the problem, you may want to consider setting
> up partial index to exclude null values.

This is a single column index.  I assumed that null column values were
not indexed.  Is my assumption incorrect?

-K

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: 8.x index insert performance
Следующее
От: Claus Guttesen
Дата:
Сообщение: Re: 8.x index insert performance