Search Postgresql Archives

How efficient is select currval?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If I insert a record into a table with a serial primary key, does
select currval fetch it from the database or does it get it from
within memory?

If it fetches it from the database, should I use a Serializable
transaction or just a read committed transaction?



Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux