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 E056E11F6750 for ; Wed, 29 Mar 2006 02:24:54 -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 36799-01 for ; Wed, 29 Mar 2006 02:24:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ctb-mesg4.saix.net (ctb-mesg4.saix.net [196.25.240.74]) by postgresql.org (Postfix) with ESMTP id 8E05111F674E for ; Wed, 29 Mar 2006 02:24:52 -0400 (AST) Received: from greg (dsl-145-175-122.telkomadsl.co.za [165.145.175.122]) by ctb-mesg4.saix.net (Postfix) with SMTP id C5BAB2B71 for ; Wed, 29 Mar 2006 08:24:50 +0200 (SAST) Message-ID: <007f01c652f9$818b4440$0200a8c0@pta.homex.co.za> Reply-To: "Greg Quinn" From: "Greg Quinn" To: References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za> <20060328173213.GO75181@pervasive.com> <442977D7.5060508@commandprompt.com> Subject: Re: Slow performance on Windows .NET and OleDb Date: Wed, 29 Mar 2006 08:24:58 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/574 X-Sequence-Number: 18011 Via insert > > When you do the population, is it via inserts or copy? > > 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/ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >