Multi-valued inserts for postgresql

[Naren]

I am using scriptella to read data from Oracle and load it into Postgresql. The performance for the insert seems slow in postgres inspite of using statement.batchSize=1000. I found that multi-valued insert statements can speedup the performance.  

An example of a multi-valued insert is below: 

1 2 3 4

INSERT INTO table (column1, column2, …) VALUES     (value1, value2, …),     (value1, value2, …) ,...;

How can I implement multi-valued insert in an ETL file in scriptella? I tried using global variables as below but it doesn't work : 

<query connection-id="con141">select * from sales  

   <script connection-id="jexl">

        etl.globals['globalVar'] =  etl.globals['globalVar'] + " VALUES (?1,?2,?3,?4,?5,?6,?7)";

    </script>  

   <script connection-id="conws" if="rownum%100==0">INSERT INTO t_comp_100_141 ?{etl.globals['globalVar']};</script>

Thanks

[Fyodor Kupolov]

Hi Naren,

I'd rather try exporting Oracle data into CSV file and try COPY command to import it. It can be done in chunks e.g. 10000 records per file.

[Naren]

Thanks Fyodor. I will try that.