Re: Out of Memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Out of Memory
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 06 Nov 2006 23:52:34 -0500
Cc: Abu Mushayeed <amushayeed@xxxxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx
Comments: In-reply-to Abu Mushayeed <abumushayeed@xxxxxxxxx> message dated "Mon, 06 Nov 2006 14:24:54 -0800"
In-reply-to: <20061106222454.38708.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
References: <20061106222454.38708.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxx>

Abu Mushayeed <abumushayeed@xxxxxxxxx> writes:
> I really could appreciate some help.

If nothing else, "set enable_hashagg = off" should help.  But have you
analyzed these tables lately?  Perhaps you have work_mem set too high?

			regards, tom lane

References:
- Re: Out of Memory
  - From: Abu Mushayeed

Prev by Date: Re: I have a question about Database management
Next by Date: Re: How do I adjust max_fsm_pages
Previous by thread: Re: Out of Memory
Next by thread: out of memory
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux