Slackware 12 and PostgreSQL 8.2.4
Anybody here got some insight into how important these performance related settings are, and how they relate to Slackware 12.
I'm especially thinking about the kernel related stuff.
Should I mess about with these things (the sysctl settings specifically), or would I be better of compiling a new kernel, or??
Hope someone can help shed some light on what is a very dark spot in my brain. :)
I have been using PostgreSQL in Slackware for years...
So far I haven't experienced any problems running PostgreSQL on a variety of PCs (most of them aren't dedicated database server and are running PostgreSQL along with X, KDE, Firefox, Eclipse and sometimes Mercury and Amarok). All those machines use my same custom kernel. None gave me any problems, excepting once when using a mutant version of OpenBravo.
I still prefer PostgreSQL over Oracle (it suits my needs).
When you say you use a custom kernel, does that mean you've compiled a kernel with the shmmax and shmall settings defined there, or are you using sysctl to set the values at runtime?
So far I've just been running PostgreSQL with the default values (Slackware 12 generic kernel, PostgreSQL slackbuilds package), and it seems to be running just fine. I'm just a tad "worried" about how it will perform under heavy load.
|All times are GMT -5. The time now is 01:30 AM.|