LinuxQuestions.org

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

TL_CLD 12-04-2007 10:04 AM

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

folkenfanel 12-04-2007 03:05 PM

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

TL_CLD 12-05-2007 01:02 AM

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


All times are GMT -5. The time now is 02:01 AM.