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.
In response to
pgsql-performance by date
|Next:||From: Oleg Bartunov||Date: 2007-01-19 10:03:05|
|Subject: Re: [PERFORM] Postgres and really huge tables |
|Previous:||From: Gavin Sherry||Date: 2007-01-18 23:09:57|
|Subject: Re: Postgres and really huge tables|