X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0BC169DC804 for ; Thu, 29 Dec 2005 05:48:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86111-03 for ; Thu, 29 Dec 2005 05:48:28 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 10D819DC822 for ; Thu, 29 Dec 2005 05:48:25 -0400 (AST) Received: from mail.androme.com (mail.androme.com [62.58.96.145]) by svr4.postgresql.org (Postfix) with ESMTP id 308B05AF9E6 for ; Thu, 29 Dec 2005 09:48:26 +0000 (GMT) Received: from [192.168.10.56] ([192.168.10.56]) by mail.androme.com (8.12.10/8.12.10) with ESMTP id jBT9mLw5002400 for ; Thu, 29 Dec 2005 10:48:21 +0100 Message-ID: <43B3B0EA.6070406@andromeiberica.com> Date: Thu, 29 Dec 2005 10:48:26 +0100 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: How import big amounts of data? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/643 X-Sequence-Number: 16464 Hi all, Which is the best way to import data to tables? I have to import 90000 rows into a column and doing it as inserts takes ages. Would be faster with copy? is there any other alternative to insert/copy? Cheers!