| From: | Seth Ladd <seth(at)picklematrix(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: ways to force index use? |
| Date: | 2003-10-14 08:18:06 |
| Message-ID: | F01852B8-FE1E-11D7-A960-000A9576D038@picklematrix.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-10-14 15:13:52 | Re: [HACKERS] Sun performance - Major discovery! |
| Previous Message | Christopher Kings-Lynne | 2003-10-14 01:43:29 | Re: go for a script! / ex: PostgreSQL vs. MySQL |