Re: ways to force index use? - Mailing list pgsql-performance

From Seth Ladd
Subject Re: ways to force index use?
Date
Msg-id F01852B8-FE1E-11D7-A960-000A9576D038@picklematrix.net
Whole thread Raw
In response to ways to force index use?  (Seth Ladd <seth@picklematrix.net>)
List pgsql-performance
On Monday, Oct 13, 2003, at 21:24 Pacific/Honolulu, mila wrote:

> Seth,
>
>> My system: RH9, PG 7.3.4, IDE, 1 gig RAM, celeron 1.7
> ...
>> Size of table: 16212 rows
>> Params: shared_buffers = 128, effective_cache_size = 8192
>
> Just in case,
> the "shared_buffers" value looks a bit far too small for your system.
> I think you should raise it to at least 1024, or so.
>
> Effective cache size could be (at least) doubled, too ==> this might
> help forcing the index use.

Thanks!  I'm just beginning to play with these numbers.  I'll
definitely try them out.

I can't wait to try out the script that will help set these parameters!
:)

Seth


pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Next
From: Tom Lane
Date:
Subject: Re: [SQL] sql performance and cache