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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
