Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5F079B5DF46 for ; Mon, 27 Jun 2011 03:30:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 19429-01-8 for ; Mon, 27 Jun 2011 06:29:57 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm17.bullet.mail.bf1.yahoo.com (nm17.bullet.mail.bf1.yahoo.com [98.139.212.176]) by mail.postgresql.org (Postfix) with SMTP id 1EF73B5DFF3 for ; Mon, 27 Jun 2011 03:09:10 -0300 (ADT) Received: from [98.139.212.148] by nm17.bullet.mail.bf1.yahoo.com with NNFMP; 27 Jun 2011 06:09:10 -0000 Received: from [98.139.212.201] by tm5.bullet.mail.bf1.yahoo.com with NNFMP; 27 Jun 2011 06:09:10 -0000 Received: from [127.0.0.1] by omp1010.mail.bf1.yahoo.com with NNFMP; 27 Jun 2011 06:09:10 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 387080.42926.bm@omp1010.mail.bf1.yahoo.com Received: (qmail 37919 invoked by uid 60001); 27 Jun 2011 06:09:10 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1309154950; bh=gDOOt0vFQfpV7hmxok6zhhveCjjqj3mFO1fMeePRIt4=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=UC36LUsB4AVO4bPE3wsAOdxPtFDudOHWNpQGvZ/n3AaA1sTf7q5bKapj8dTmzDGhPH/CRAsGM7hdxT4YWna4/dLcq2lVRym7rrh5lVXiDFYQ9IEMA6XxdQJhMJlPMvxYIrysB2lB7O345PSTBir/860AWXt7xX7wW4acTVOBTJw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=tOZ4xKs7eFCzCXLVxhMrcUSFN53zNSkQOoZZwwUdlYcFI6apHrOehtbeAaDh5WwK8s96Kot7w0tEr/CEM7cpnChUhwcD9zMN8s6wiBsgWR1tErp2dDES0U2aIiFSeAWaP3gYuKFkpVolsc0vibthYLgbVEHA8rRWhiZ7C0ez7uI=; Message-ID: <333801.29762.qm@web161424.mail.bf1.yahoo.com> X-YMail-OSG: AlTG2_MVM1l3C7wtBd.laH4fzDYRSDcB4WXh20Xj6ssOTW7 76INi4rrQ8bCHAgoWbvCuBIu6oVxr6xzha.LwTj9FcoTGUEOJDlHVvssDn1. g_u4lR1IbSDTsZn.gGMC3siDSDogjzP8aPHFPDJBAg5Oc7ytUbW7WaNuvL6h HPvYopth9AHjYKm0FQ_dzaAQPPHbJzbIasfAmMVMuQxktziShrFnhCUQ1_Xv WlDP9pMR9s1joAUSy6Y6fuQD4K7xN.9Q8DHodLIWRul8e6ANFaFN64EP8WvA 6O5G_IadM32fkIZdDNzl5QL.MDPhH7831LG1C09TXwxNcQ_02pjmEpRocPVV VHbkQUdoBhBFbUeKzZ33q5jBy4ReYWvVS8otmcdMWyPNGMYN.Ifm5_g-- Received: from [124.120.220.3] by web161424.mail.bf1.yahoo.com via HTTP; Sun, 26 Jun 2011 23:09:10 PDT X-Mailer: YahooMailClassic/14.0.3 YahooMailWebService/0.8.111.304355 Date: Sun, 26 Jun 2011 23:09:10 -0700 (PDT) From: chester c young Subject: best performance for simple dml To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1181573717-1006212829-1309154950=:29762" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.802 tagged_above=-5 required=5 tests=BAYES_50=0.8, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201106/92 X-Sequence-Number: 35558 ---1181573717-1006212829-1309154950=:29762 Content-Type: text/plain; charset=us-ascii what is the best performance / best practices for frequently-used simple dml, for example, an insert 1. fast-interface 2. prepared statement calling "insert ..." with binary parameters 3. prepared statement calling "myfunc(..." with binary parameters; myfunc takes its arguments and performs an insert using them ---1181573717-1006212829-1309154950=:29762 Content-Type: text/html; charset=us-ascii
what is the best performance / best practices for frequently-used simple dml, for example, an insert

1. fast-interface

2. prepared statement calling "insert ..." with binary parameters

3. prepared statement calling "myfunc(..." with binary parameters; myfunc takes its arguments and performs an insert using them

---1181573717-1006212829-1309154950=:29762--