Postgres Pro
Downloads
Home   >   mailing lists

Re: Configuration Advice - Mailing list pgsql-performance

From Arjen van der Meijden
Subject Re: Configuration Advice
Date
Msg-id 45B061F0.6040309@tweakers.net
Whole thread Raw
In response to Re: Configuration Advice  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Postgres and really huge tables
Next
From: Oleg Bartunov
Date:
Subject: Re: [pgsql-advocacy] Postgres and really huge tables