LinuxQuestions.org - Slackware 12 and PostgreSQL 8.2.4

- Slackware (https://www.linuxquestions.org/questions/slackware-14/)

- - Slackware 12 and PostgreSQL 8.2.4 (https://www.linuxquestions.org/questions/slackware-14/slackware-12-and-postgresql-8-2-4-a-604433/)

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.

http://www.postgresql.org/docs/8.2/i...resources.html
http://www.postgresql.org/docs/8.2/i...-resource.html

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. :)

Thomas

I have been using PostgreSQL in Slackware for years...

Code:

postgres@evenstar:~$ psql

Welcome to psql 8.2.4, the PostgreSQL interactive terminal.



Type:  \copyright for distribution terms

      \h for help with SQL commands

      \? for help with psql commands

      \g or terminate with semicolon to execute query

      \q to quit

I have been using PostgreSQL 8.2.4 since July. No problems so far. I use a custom kernel.

Code:

david@evenstar:~# cat /proc/sys/kernel/shmmax

33554432



david@evenstar:~# cat /proc/sys/kernel/shmall

2097152

My shmall value is exactly the one recommended by that page, but my shmmax is lower.

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).

Quote:

Originally Posted by folkenfanel (Post 2980159)

I have been using PostgreSQL 8.2.4 since July. No problems so far. I use a custom kernel.

Code:

david@evenstar:~# cat /proc/sys/kernel/shmmax

33554432



david@evenstar:~# cat /proc/sys/kernel/shmall

2097152

My shmall value is exactly the one recommended by that page, but my shmmax is lower.

Hey folkenfanel,

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.

:)
Thomas