Re: 8.x index insert performance

From: Kelly Burkhart <kelly(at)tradebotsystems(dot)com>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.x index insert performance
Date: 2005-10-31 17:51:46
Message-ID: 1130781106.7026.46.camel@krb06.tradebot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Claus Guttesen 2005-10-31 19:02:26 Re: 8.x index insert performance
Previous Message Merlin Moncure 2005-10-31 17:32:03 Re: 8.x index insert performance