Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 052539FC0F7 for ; Fri, 12 Oct 2007 18:49:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 91685-07 for ; Fri, 12 Oct 2007 18:48:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc2-s9.bay0.hotmail.com (bay0-omc2-s9.bay0.hotmail.com [65.54.246.145]) by postgresql.org (Postfix) with ESMTP id C99599FC0F3 for ; Fri, 12 Oct 2007 18:49:00 -0300 (ADT) Received: from BAY124-W42 ([207.46.11.205]) by bay0-omc2-s9.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Fri, 12 Oct 2007 14:48:59 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_e88b3101-17d2-4f70-86d7-ca7f4b7f7a72_" X-Originating-IP: [86.81.58.36] From: henk de wit To: Erik Jones CC: "pgsql-performance@postgresql.org" Subject: Re: Huge amount of memory consumed during transaction Date: Fri, 12 Oct 2007 23:48:59 +0200 Importance: Normal In-Reply-To: References: <13678.1192114295@sss.pgh.pa.us> <15391.1192152419@sss.pgh.pa.us> <4144.1192219156@sss.pgh.pa.us> MIME-Version: 1.0 X-OriginalArrivalTime: 12 Oct 2007 21:48:59.0513 (UTC) FILETIME=[B2339E90:01C80D19] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/157 X-Sequence-Number: 27179 --_e88b3101-17d2-4f70-86d7-ca7f4b7f7a72_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable > > I have work_mem set to 256MB. =20 > 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! =20 > Explain is your friend in that respect. It shows all the operators, but it doesn't really say that these all will a= ctually 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/= --_e88b3101-17d2-4f70-86d7-ca7f4b7f7a72_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable > > 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 adju= st it to a more saner level. Thanks a lot for the advice everyone!

= > Explain is your friend in that respect.

It shows all the operat= ors, 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 bo= und is.

regards


Express yourself instantly with MSN M= essenger! MSN Messenger = --_e88b3101-17d2-4f70-86d7-ca7f4b7f7a72_--