Postgres Pro
Downloads
Home   >   mailing lists

Re: best performance for simple dml - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: best performance for simple dml
Date
Msg-id BANLkTimcokKM=MTAu1-kZFPsNGW8Lgj3rw@mail.gmail.com
Whole thread Raw
In response to best performance for simple dml  (chester c young <chestercyoung@yahoo.com>)
Responses Re: best performance for simple dml  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
Tree view
Hello

try it and you will see. Depends on network speed, hw speed. But the most fast is using a COPY API

http://www.postgresql.org/docs/9.0/interactive/libpq-copy.html

Regards

Pavel Stehule


2011/6/27 chester c young <chestercyoung@yahoo.com>
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


pgsql-sql by date:

Previous
From: chester c young
Date:
Subject: best performance for simple dml
Next
From: chester c young
Date:
Subject: Re: best performance for simple dml