Re: Streaming ResultSet

From: albertwang <wang_yanlei(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Streaming ResultSet
Date: 2017-06-23 00:08:46
Message-ID: 1498176526105-5968275.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi Kevin,

How is your question / suggestion going?

I met the same problem. Our company uses PostgreSQL as the OLTP system. I am
working on an ETL project which reads data from a PostgreSQL db, transforms
the data and then load the data into another PostgreSQL db. The ETL tool
uses JDBC.

My problem is that the ETL won't start to transform the data before the
whole data result set has been loaded into memory.

I would like to do the data transforming and loading while extracting data.

Do you know if there is any progress reagrding the streaming result set? As
I know, MySQL does support it.

Thank you.

Regards,
Albert

--
View this message in context: http://www.postgresql-archive.org/Streaming-ResultSet-tp2168704p5968275.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2017-06-23 05:42:15 Re: Streaming ResultSet
Previous Message Michael Paquier 2017-06-21 00:16:38 Re: [HACKERS] Channel binding support for SCRAM-SHA-256