Re: Huge amount of memory consumed during transaction

From: henk de wit <henk53602(at)hotmail(dot)com>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Huge amount of memory consumed during transaction
Date: 2007-10-12 21:48:59
Message-ID: BAY124-W42AEFF8386BF570F561B8DF5A00@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > I have work_mem set to 256MB.
> Wow. That's inordinately high. I'd recommend dropping that to 32-43MB.

Ok, it seems I was totally wrong with the work_mem setting. I'll adjust it to a more saner level. Thanks a lot for the advice everyone!

> Explain is your friend in that respect.

It shows all the operators, but it doesn't really say that these all will actually run in parallel right? Of course I guess it would give a good idea about what the upper bound is.

regards

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-10-12 22:03:46 Re: How to speed up min/max(id) in 50M rows table?
Previous Message henk de wit 2007-10-12 21:40:54 Re: How to speed up min/max(id) in 50M rows table?