In response to Brad Nicholson :
> 1: Is the default work_mem pre-allocated to the Postgres processes - or
> does it get allocated when needed? Say I have work_mem at 30MB - will
> Postgres allocate that 30MB on connection, or only when it needed by a
> query?
It's allocated on demand and freed w
1: Is the default work_mem pre-allocated to the Postgres processes - or
does it get allocated when needed? Say I have work_mem at 30MB - will
Postgres allocate that 30MB on connection, or only when it needed by a
query?
2: If work_mem is, say, 30MB, and my query needs 10MB - will Postgres
alloca
