Horton
Menu

Re: Configuration Advice

Arjen van der Meijden <acmmailing@tweakers.net>

View thread
From: Arjen van der Meijden <acmmailing@tweakers.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Date: 2007-01-19T06:15:12Z
Lists: pgsql-performance 
On 18-1-2007 23:11 Tom Lane wrote:
> Increase work_mem?  It's not taking the hash because it thinks it won't
> fit in memory ...

When I increase it to 128MB in the session (arbitrarily selected 
relatively large value) it indeed has the other plan.

Best regards,

Arjen