On 06/19/2018 04:20 PM, Ravi Krishna wrote:
Thanks all for replying. I see that I did not explain my requirement in
detail. So let me
explain it in detail.
1. Currently we have a legacy app running in DB2/LUW. Application writes
to it either via Java program
or uses a custom ETL scripts using a vendor product.
2. We want to migrate it to DB2 and eliminate vendor ETL tool.
3. We now have a catch-22 situation. Should we spend time porting the
app to PG without first verifying
that PG can perform as well as DB2. In other words, if some sort of
testing rules out PG as a good
replacement for DB2, why even bother to port. Of course that does
not prove conclusively that if PG
passes the test, then it would mean that the app will work just as
fine. But at least basic test will tell
that we are not on a wrong path.
4. What I am planning is:
4.a Get a set of large tables exported as a pipe delimited text file.
4.b Load them in both DB2 and PG on a similar h/w
4.c Run OLAP queries.
4.b is to test i/o. Our app is sensitive to the load times and some of
the tables are really wide.
4.c is to test maturity of PG in handling complex OLAP SQLs. From what I
have read, while PG
optimizer is very good in handling OLTP, it is not, as yet, as
good in OLAP queries.
I just want to keep the testing tool same in 4.b for both db2 and pg. If
To me, 4.b means find the tool that minimizes the load time in each
database. This is not necessarily the same tool for each.
COPY is the only way,
we will use it with something comparable on the DB2 side.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
