Re: Draft release notes complete

On Wed, May 16, 2012 at 10:49:25PM +0300, Heikki Linnakangas wrote:
> On 16.05.2012 22:38, Jeff Janes wrote:
> >For item:
> >Improve COPY performance by adding tuples to the heap in batches
> >(Heikki Linnakangas)
> >
> >I think we should point out that the batching only applies for COPY
> >into unindexed tables.  Nice as the feature is, that is pretty big
> >limitation not to mention.
> 
> No, it applies to indexed tables too. However, if there are indexes
> on the table, the overhead of updating the indexes will probably
> make any speedup in the heap insertions look tiny in comparison.
> 
> The optimization doesn't apply if the table has BEFORE or INSTEAD OF
> triggers, or volatile DEFAULT expressions need to be evaluated.

So, I will assume the existing wording is fine.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +