Re: Good way to insert/update when you're not sure of duplicates?

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Good way to insert/update when you're not sure of duplicates?
Date: 2003-09-26 15:15:48
Message-ID: 200309262045.48106.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 26 September 2003 20:48, Dennis Gearon wrote:
> Shridhar Daithankar wrote:
> > In addition to that, you can try inserting from multiple backends
> > simaltenously to speed up the whole process.
> >
> > And I don't like the modes idea OP gave. I would rather follow
> > insert->if-error-update mode in a transaction for each record. And
> > fork over say 20/40 parallel backends to achieve good speed.
>
> I didn't think mulitple backends worked.

Why? Why can't you insert using multiple backends? I mean is there a problem?

Shridhar

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2003-09-26 15:17:25 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Previous Message Tom Lane 2003-09-26 15:01:34 initdb failure (was Re: [GENERAL] sequence's plpgsql)