Re: 8.x index insert performance - Mailing list 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