On Sun, Aug 25, 2013 at 11:08 PM, 高健 <luckyjackgao(at)gmail(dot)com> wrote:
> Hello:
>
> Sorry for disturbing.
>
> I am now encountering a serious problem： memory is not enough.
>
> My customer reported that when they run a program they found the totall
> memory and disk i/o usage all reached to threshold value(80%).
>
> That program is written by Java.
> It is to use JDBC to pull out data from DB, while the query joined some
> table together, It will return about 3000,000 records.
> Then the program will use JDBC again to write the records row by row , to
> inert into another table in the DB.
What is using the memory, the postgres backend or the client program?
Cheers,
Jeff