From: | Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgresql - Currval Vs Session Pool |
Date: | 2013-06-09 15:59:31 |
Message-ID: | CAKc1ktUJy=gazYN-PwR8O9xzoEsfS5i1_YfKFbHP+qyHp=LJwQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello, all.
In the PostgreSQL documentation I found "currval: Return the value most
recently obtained by nextval for this sequence in the current session ...."
In other documentations (pgpool, for example), I found "Connection Pooling
pgpool-II saves connections to the PostgreSQL servers, and reuse them
whenever a new connection with the same properties (i.e. username,
database, protocol version) comes in. It reduces connection overhead, and
improves system's overall throughput"
Then, I have the following question: PostgreSQL differentiates between
sessions created for the same user?
Background
==========
- I, traditionalmente, have several user in a web application (user table,
for example); but I use only one postgresql-db-user to get connetions to
database
- If a CREATE (CRUD) operation uses a head-detail couple of tables, then in
a transaction: data in HEAD table is inserted; next, the value for the
primary key is achieved from currval function; next references to head
table is inserted in detail table.
Other questions
===============
- If I use a "bd_user" user to get connections to PostgreSQL and I use
connetions Pool; if CONNECTION_01 and CONNECTION_02 concurrently try to
get value from "currval" function, what happens?
- Exist best practices to do what I trying.
Thank you, in advance.
------------------------
Gustavo Amarilla
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2013-06-09 16:47:54 | Re: Postgresql - Currval Vs Session Pool |
Previous Message | dinesh kumar | 2013-06-09 13:17:40 | Re: Postgres 8.4 stopped working---Please urgent help needed |