On Nov 5, 2011, at 10:46, Brandon Phelps <bphe...@gls.com> wrote: > On 11/5/2011 10:35 AM, Raymond O'Donnell wrote: >> On 05/11/2011 04:34, Brandon Phelps wrote > > With the method you outlined will I notice any huge performance impacts? The > application would be parsing incoming data from another 3rd party application > and could, at times, be executing the function in very fast succession, > although never twice at the exact same moment (single threaded application, > pending events will just block until they're up). > > Thanks again! >
You would probably be much better off importing the third-party data into a staging table, performing all of your "key" creation, and then inserting the data into your final tables. While triggers would work you end up with a lot of pointless effort when in most cases keys are likely to exist. David J. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
