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

Reply via email to