How efficient is select currval? - Mailing list pgsql-general

From Chris Velevitch
Subject How efficient is select currval?
Date
Msg-id b0a3bf780512081619o1460b6c1ndb7b64835d18557d@mail.gmail.com
Whole thread Raw
Responses Re: How efficient is select currval?
List pgsql-general
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

pgsql-general by date:

Previous
From: Jeffrey Melloy
Date:
Subject: Re: find last day of month
Next
From: CSN
Date:
Subject: copy with where query?