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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general