Horton
Menu

Re: Best COPY Performance

Joshua D. Drake <jd@commandprompt.com>

View thread
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Jim C. Nasby" <jim@nasby.net>
Cc: Worky Workerson <worky.workerson@gmail.com>, Merlin Moncure <mmoncure@gmail.com>, pgsql-performance@postgresql.org
Date: 2006-10-23T22:10:33Z
Lists: pgsql-performance 
> Ultimately, you might be best of using triggers instead of rules for the
> partitioning since then you could use copy. Or go to raw insert commands
> that are wrapped in a transaction.

My experience is that triggers are quite a bit faster than rules in any
kind of partitioning that involves more than say 7 tables.

Sincerely,

Joshua D. Drake


-- 

   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
   Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate