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-W27B12597CAD62CB7C05790F5A00@phx.gbl
Whole thread Raw
In response to Re: Huge amount of memory consumed during transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Huge amount of memory consumed during transaction  (Erik Jones <erik@myemma.com>)
List pgsql-performance
Tree view
> It looks to me like you have work_mem set optimistically large. This
> query seems to be doing *many* large sorts and hashes:

I have work_mem set to 256MB. Reading in PG documentation I now realize that "several sort or hash operations might be running in parallel". So this is most likely the problem, although I don't really understand why memory never seems to increase for any of the other queries (not executed in a transaction). Some of these are at least the size of the query that is giving problems.

Btw, is there some way to determine up front how many sort or hash operations will be running in parallel for a given query?

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: henk de wit
Date:
Subject: Re: How to speed up min/max(id) in 50M rows table?