Re: 0ut of Memory Error during Vacuum Analyze and Create Index - Mailing list pgsql-performance

"Tomeh, Husam" <htomeh@firstam.com> writes:
> mtrac=# show maintenance_work_mem ;
>  maintenance_work_mem
> ----------------------
>  1048576        <======
> (1 row)

> mtrac=#
> mtrac=#
> mtrac=# create index mort_ht on mortgage(county_id,mtg_rec_dt);
> ERROR:  out of memory                                               <===
> DETAIL:  Failed on request of size 134217728.               <===

It would be useful to look at the detailed allocation info that this
(should have) put into the postmaster log.  Also, if you could get
a stack trace back from the error, that would be even more useful.
To do that,
    * start psql
    * determine PID of connected backend (use pg_backend_pid())
    * in another window, as postgres user,
        gdb /path/to/postgres backend-PID
        gdb> break errfinish
        gdb> cont
    * issue failing command in psql
    * when breakpoint is reached,
        gdb> bt
        ... stack trace printed here ...
        gdb> q

            regards, tom lane