On Tue, Apr 24, 2012 at 11:30 AM, David Fetter <david@xxxxxxxxxx> wrote: > On Tue, Apr 24, 2012 at 08:12:10AM +1000, Chris Angelico wrote: >> Of course, the question I never asked (never bothered to, really) >> was: Is it really any better than simply doing the first insert and >> retrieving the ID in my application? :) > > One crucial difference is the number of round trips to the database. Yeah, which gives it the potential to be faster, but I never actually measured anything. Would be curious to know if it becomes better at X table size, or something. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general