Re: Memory usage - indexes - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Memory usage - indexes
Date
Msg-id 4CA4FAA6.2030002@catalyst.net.nz
Whole thread Raw
In response to Re: Memory usage - indexes  (Tobias Brox <tobixen@gmail.com>)
List pgsql-performance
On 30/09/10 01:09, Tobias Brox wrote:
> With the most popular trans type it chose another plan and it took
> more than 3s (totally unacceptable):
>
>

Try tweeking effective_cache_size up a bit and see what happens - I've
found these bitmap plans to be sensitive to it sometimes.

regards

Mark


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: gist indexes for distance calculations
Next
From: Marcelo Zabani
Date:
Subject: Re: gist indexes for distance calculations