LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices



Reply
 
Search this Thread
Old 12-04-2007, 11:04 AM   #1
TL_CLD
Member
 
Registered: Sep 2006
Posts: 342

Rep: Reputation: 34
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
 
Old 12-04-2007, 04:05 PM   #2
folkenfanel
Member
 
Registered: Sep 2004
Location: formerly Fanelia and Zaibach
Distribution: Slackware-current with KDE 4.8.5
Posts: 303

Rep: Reputation: 36
Talking 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).
 
Old 12-05-2007, 02:02 AM   #3
TL_CLD
Member
 
Registered: Sep 2006
Posts: 342

Original Poster
Rep: Reputation: 34
Quote:
Originally Posted by folkenfanel View Post

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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use PostgreSQL on slackware (10.1) tuamtium Linux - Newbie 1 08-14-2005 02:46 AM
postgresql on slackware 10 dublinclontarf Slackware 6 08-13-2004 01:04 PM
postgresql-7.4 no workie in slackware 9.1 digital bots Linux - Software 6 06-11-2004 09:22 AM
Slackware Postgresql and PHP squirreldogger Slackware 2 11-21-2003 06:19 PM
slackware 9.0 -- no postgresql... alixx Slackware 1 07-12-2003 01:12 PM


All times are GMT -5. The time now is 12:59 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration