[rt-users] Performance on PostgreSQL

[Vivek Khera]

On Oct 15, 2006, at 8:23 PM, Joby Walker wrote:

> As was pointed out to me the current value function returns the  
> last value used for that connection, so from the pgsql side it is  
> multithread safe -- but I don't know how using a connection pooling  
> system like SQLRelay impacts things (because we might use a  
> sqlrelay in the future is one of the reasons I modified our  
> instance of SB).

Well, you're not gonna multiplex the connection during the same  
transaction, so it will be safe to call the last_insert_id() method  
from DBD::Pg to query the sequence number of the last insert.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2530 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061016/5e89a2fd/attachment.bin>