| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Vivek Khera <khera(at)kcilink(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Date: | 2003-10-14 01:29:56 |
| Message-ID: | 3F8B5194.1000106@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
>>>If shmmax and shmmall are too small, then:
>>>PostgreSQL requires some more shared memory to cache some tables, x
>>>Mb, do you want to increase your OS kernel parameters?
>>>Tweak shmmax and shmmall
>
>
> CK> Note that this still requires a kernel recompile on FreeBSD :(
>
> According to whom? sysctl is your friend. Some sysctl settings may
> require reboot, but I don't think the SHM ones do.
Hmmm...you may be right - I can't prove it now...
houston# sysctl -w kern.ipc.shmmax=99999999999
kern.ipc.shmmax: 33554432 -> 2147483647
Hrm. Ok. Maybe they've changed that in some recent version :)
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-10-14 01:43:29 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Previous Message | Edmund Dengler | 2003-10-14 01:16:33 | SET within a function? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-10-14 01:43:29 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Previous Message | Bruce Momjian | 2003-10-14 00:48:13 | Re: [HACKERS] Sun performance - Major discovery! |