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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
