From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
Subject: Re: SQL Query Validate Records Multiple Tables - HelpNeeded
Date: Wed, 16 May 2007 08:59:53 +0200
Message-ID: <464AC809.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <1179268346.212283.25370@w5g2000hsg.googlegroups.com>
References: <1179235046.748509.130630@y80g2000hsf.googlegroups.com>
<11792683 46.212283.25370@w5g2000hsg.googlegroups.com>
I'm working on something similar at the moment. Don't know about you, but I have an additional problem: I have to deal with rather large datasets (>20000 recs per query) to be moved between the two databases (Oracle and PostgreSQL in my case). After doing lots of performance test, for me the conclusion was that dblink doesn't really work, dbi-link works but has way too much overhead and is way to slow.
So finally I installed plperlu and wrote some functions of my own and these work at a very acceptable speed. Transferring data between two different Oracle databases was on average not faster than between Oracle and PostgreSQL.
>>> Rodrigo De León <rdeleonp@gmail.com> 2007-05-16 0:32 >>>
On May 15, 8:17 am, Paul251 <savethe...@gmail.com> wrote:
> Hello...
>
> I am trying to validate a asset number (10 Characters) from one table
> to another table. Problem is they are in two different DB's and
> haven't done that before?
>
> Basically trying to take record 1 from Table 1/DB1 and validate it
> against record 1 in Table 2/DB2 if the record doesn't exist in Table 2/
> DB2 update the flag to N in Table 1/DB1..... Seems easy but been
> working on it for about a week now no luck.... :-( I have the mostly
> the same colums in both tables but Table 2/DB2 is the host table I
> need to verify from....
>
> Does anyone have any help or code to help me do this??
>
> Thanks
See:
http://www.postgresql.org/docs/faqs.FAQ.html#item4.17https://projects.commandprompt.com/public/pgsql/browser/trunk/pgsql/contrib/dblink/doc/query?rev=262...
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be
Subject: Re: SQL Query Validate Records Multiple Tables - HelpNeeded
In-Reply-To: <464AC809.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox