On Sun, Aug 25, 2013 at 11:08 PM, 高健 <luckyjackgao@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
