Db Name | insert | select | update | delete |
  PostgreSql |   8034 |   9808 |   6857 |   9314 |
       MySql |  22675 |  16035 |  18782 |  19992 |
    TimesTen |  85792 | 198601 |  70466 |  66461 |

CREATE TABLE bench (
    id integer NOT NULL, 
    value integer NOT NULL, 
    CONSTRAINT bench_pk PRIMARY KEY (id) 
);

INSERT INTO bench (id, value) VALUES ($1, $2)
SELECT value FROM bench WHERE id=$1
UPDATE bench SET value=$1 WHERE id=$2
DELETE FROM bench WHERE id=$1

db_insert(1,1);
db_insert(1,2);
db_insert(2,3);
db_select(2,&value);

Retcode [-1] when executing SQLExecute(stmt_insert)
Error [-1] in SQLExecute(stmt_insert)ERROR:
[unixODBC]ERROR: duplicate key value violates unique constraint "bench_pk"
Key (id)=(1) already exists.;
Error while executing the query
ODBC Error/Warning = 23505, Additional Error/Warning = 7

Retcode [-1] when executing SQLExecute(stmt_insert)
Error [-1] in SQLExecute(stmt_insert)ERROR:
[unixODBC]Error while executing the query
ODBC Error/Warning = S1000, Additional Error/Warning = 7

             Db Name |select1 | insert | select | update | delete |
  PostgreSql (libpq) |  22990 |  15975 |  16416 |  10610 |  15529 | unix_socket
  PostgreSql (libpq) |  14877 |  11791 |  12405 |   9006 |  11950 | tcp/ip
   PostgreSql (ODBC) |  11888 |   9635 |   9026 |   7773 |   9625 | tcp/ip
        MySql (ODBC) |  24884 |  22349 |  15943 |  18581 |  19848 | unix_socket, Memory
        MySql (ODBC) |  24806 |  14148 |  13864 |  11473 |  12225 | unix_socket, InnoDB 
        MySql (ODBC) |  13934 |  16372 |  12617 |  14208 |  15150 | tcp/ip, Memory
        MySql (ODBC) |  13103 |  11727 |  11289 |   9972 |  10438 | tcp/ip, InnoDB
     TimesTen (ODBC) | 143061 |  82169 | 207125 |  73152 |  62719 | shm
     TimesTen (ODBC) |   7796 |  14282 |   7787 |  13910 |  12945 | tcp/ip

void db_prepare() {
....
    res = PQprepare(conn, STMT_ID_SELECT1, Q_SELECT1, 0, NULL);
    CHECK_RESULT(res);
    PQclear(res);
....
}

void db_select1(int32_t* value) {
    if (debug) {
        fprintf(stderr, "db_select1()\n");
    }
    PGresult* res = PQexecPrepared(conn,
            STMT_ID_SELECT1,
            0,
            NULL,
            NULL,
            NULL,
            1);
    CHECK_RESULT(res);
    *value = -1;
    if (PQntuples(res) == 0) {
        fprintf(stderr, "db_select1() return no rows\n");
        if (exit_on_error) {
            exit(EXIT_FAILURE);
        }
    } else {
        *value = ntohl(*(int32_t *) PQgetvalue(res, 0, 0));
        if (debug) {
            fprintf(stderr, "db_select1() return %d\n", *value);
        }
    }
    PQclear(res);
}

processor	: 2
vendor_id	: GenuineIntel
cpu family	: 6
model		: 23
model name	: Intel(R) Xeon(R) CPU           E5450  @ 3.00GHz
stepping	: 6
cpu MHz		: 3000.405

top - 06:46:28 up 50 days, 21:39,  1 user,  load average: 0.27, 0.23, 0.18
Tasks: 166 total,   4 running, 162 sleeping,   0 stopped,   0 zombie
Cpu(s): 41.3%us, 10.2%sy,  0.0%ni, 47.6%id,  0.3%wa,  0.0%hi,  0.6%si,  0.0%st
Mem:  12194176k total,  6869348k used,  5324828k free,   198620k buffers
Swap:        0k total,        0k used,        0k free,  5654048k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                                                                         
23348 postgres  20   0 6377m 556m 551m S 19.6  4.7 231:14.37 postgres: appuser pcrf [local]                                                                                                                                                  
23308 postgres  20   0 6377m 556m 550m S 18.9  4.7 230:59.38 postgres: appuser pcrf [local]                                                                                                                                                  
23338 postgres  20   0 6377m 556m 550m S 18.6  4.7 231:06.01 postgres: appuser pcrf [local]                                                                                                                                                  
23346 postgres  20   0 6377m 556m 550m S 18.6  4.7 231:09.18 postgres: appuser pcrf [local]                                                                                                                                                  
23349 postgres  20   0 6377m 556m 550m R 18.6  4.7 231:09.39 postgres: appuser pcrf [local]                                                                                                                                                  
23351 postgres  20   0 6377m 557m 551m R 18.6  4.7 231:10.45 postgres: appuser pcrf [local]                                                                                                                                                  
23245 root      15  -5  908m  13m 6272 S 13.6  0.1 161:41.58 /opt/pcrf_core/bin/pcrf_core worker 1                                                                                                                                           
23244 root      15  -5  908m  13m 6296 S 13.3  0.1 161:50.89 /opt/pcrf_core/bin/pcrf_core worker 0                                                                                                                                           
23247 root      15  -5  908m  13m 6268 S 13.3  0.1 161:41.48 /opt/pcrf_core/bin/pcrf_core worker 2                                                                                                                                           
23248 root      15  -5  908m  13m 6264 S 12.9  0.1 161:45.03 /opt/pcrf_core/bin/pcrf_core worker 3                                                                                                                                           
23250 root      15  -5  908m  13m 6292 S 12.9  0.1 161:31.96 /opt/pcrf_core/bin/pcrf_core worker 4                                                                                                                                           
23251 root      15  -5  908m  13m 6268 S 12.9  0.1 161:39.92 /opt/pcrf_core/bin/pcrf_core worker 5                                                                                                                                           
23374 root      15  -5 1306m 516m 4004 S  7.0  4.3  84:36.92 /opt/drug/bin/drug -d -l notice