"Tomeh, Husam" <htomeh@xxxxxxxxxxx> 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
