Re: [PERFORM] 0ut of Memory Error during Vacuum Analyze and Create Index

2006-02-14 Thread Tom Lane
"Tomeh, Husam" <[EMAIL PROTECTED]> 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

Re: [PERFORM] 0ut of Memory Error during Vacuum Analyze and Create Index

2006-02-14 Thread Tom Lane
"Tomeh, Husam" <[EMAIL PROTECTED]> writes: > I have run pg_dump and had no errors. I also got this error when > creating one index but not another. When I lowered my > maintenance_work_mem, the create index succeeded. Create index too? Hm. That begins to sound more like a memory leak. Do you ha