Re: [PERFORM] ways to force index use?

[Seth Ladd]

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


Advertising






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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster