| From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
|---|---|
| To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
| Cc: | Pgsql performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Vacuums on large busy databases |
| Date: | 2006-09-14 20:30:46 |
| Message-ID: | cone.1158265846.124028.75607.5001@35st-server.simplicato.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Dave Cramer writes:
>> What is a reasonable number?
>> I estimate I have at least 1 to 2 GB free of memory.
> You are using 6G of memory for something else ?
Right now adding up from ps the memory I have about 2GB.
Have an occassional program which uses up to 2GB.
Then I want to give some breathing room for when we have more connections so
that work_mem doesn't make the macihne hit swap.
At 32MB say worst case scenario I may have 50 operations using those 32MB,
that's about 1.5GB.
2+2+1.5 = 5.5
So I believe I have free about 2.5GB
> effective cache should be set to 75% of free memory
So I will increase to 1.5GB then.
I may have more memory, but this is likely a safe value.
Thanks for the feedback.. Didn't even know about this setting.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Stone | 2006-09-14 20:42:22 | Re: Vacuums on large busy databases |
| Previous Message | Bruce Momjian | 2006-09-14 19:25:17 | Re: Performance problem with Sarge compared with |