saravanan Chow, 20.02.2014 06:41: > There is nothing in the pg_log. > Log files contains : "2014-02-20 10:58:55 IST LOG: received fast shutdown request > 2014-02-20 10:58:55 IST LOG: aborting any active transactions > 2014-02-20 10:58:55 IST LOG: autovacuum launcher shutting down > 2014-02-20 10:58:55 IST LOG: shutting down > 2014-02-20 10:58:55 IST LOG: database system is shut down " > It is working upto 1.5GB , more than 1.5GB its throwing the error. > Sounds as if you are using 32bit Windows (or Postgres). Under 32bit, a single process cannot allocate more than 2GB in total. Windows also reserves some memory from that maximum and therfor the actual maximum memory for a 32bit process is somewhere around 1.5GB -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general