| From: | Vivek Khera <khera(at)kcilink(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Date: | 2003-10-10 21:14:25 |
| Message-ID: | 16263.8497.95525.673249@yertle.int.kciLink.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
>>>>> "JB" == Josh Berkus <josh(at)agliodbs(dot)com> writes:
JB> Vivek,
NB> shared_buffers = 1/16th of total memory
NB> effective_cache_size = 80% of the supposed kernel cache.
>>
>> Please take into account the blocksize compiled into PG, too...
JB> We can;t change the blocksize in a script that only does the .conf
JB> file. Or are you suggesting something else?
when you compute optimal shared buffers and effective cache size,
these are in terms of blocksize. so if I have 16k block size, you
can't compute based on default 8k blocksize. at worst, it would have
to be a parameter you pass to the tuning script.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Bartlett | 2003-10-10 21:14:35 | Re: Interfaces that support cursors |
| Previous Message | David Busby | 2003-10-10 21:10:30 | Re: Table partitioning for maximum speed? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-10-10 21:22:57 | Re: further testing on IDE drives |
| Previous Message | David Busby | 2003-10-10 21:04:51 | Index/Foreign Key Question |