Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge amount of memory consumed during transaction - Mailing list pgsql-performance

From henk de wit
Subject Re: Huge amount of memory consumed during transaction
Date
Msg-id BAY124-W42AEFF8386BF570F561B8DF5A00@phx.gbl
Whole thread Raw
In response to Re: Huge amount of memory consumed during transaction  (Erik Jones <erik@myemma.com>)
Responses Re: Huge amount of memory consumed during transaction
List pgsql-performance
Tree view
> > 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! MSN Messenger

pgsql-performance by date:

Previous
From: henk de wit
Date:
Subject: Re: How to speed up min/max(id) in 50M rows table?
Next
From: Tom Lane
Date:
Subject: Re: How to speed up min/max(id) in 50M rows table?