| From: | Vivek Khera <khera(at)kcilink(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Date: | 2003-10-10 20:26:58 |
| Message-ID: | x7wubcon3h.fsf@yertle.int.kciLink.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
>>>>> "NB" == Nick Barr <nicky(at)chuckie(dot)co(dot)uk> writes:
NB> So far:
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...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2003-10-10 20:33:30 | log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze |
| Previous Message | Vivek Khera | 2003-10-10 20:15:43 | Re: Table partitioning for maximum speed? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-10-10 20:38:18 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Previous Message | Vivek Khera | 2003-10-10 20:22:08 | Re: go for a script! / ex: PostgreSQL vs. MySQL |