best performance for simple dml

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: best performance for simple dml
Date: 2011-06-27 06:09:10
Message-ID: 333801.29762.qm@web161424.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2011-06-27 06:35:19 Re: best performance for simple dml
Previous Message John Fabiani 2011-06-23 16:45:58 Re: Union out performs the single statement