pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mike Rylander <mrylander@gmail.com>
To: Mark Rinaudo <mark@bowmansystems.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql on an AMD64 machine
Date: Mon, 6 Jun 2005 16:59:21 -0400
Message-ID: <b918cf3d05060613593a73a18a@mail.gmail.com> (raw)
In-Reply-To: <1118080420.1644.23.camel@penguin1>
References: <1118080420.1644.23.camel@penguin1>

On 06 Jun 2005 12:53:40 -0500, Mark Rinaudo <mark@bowmansystems.com> wrote:
> I'm not sure if this is the appropriate list to post this question to
> but i'm starting with this one because it is related to the performance
> of Postgresql server.  I have a Penguin Computing dual AMD 64 bit
> opteron machine with 8 Gigs of memory.  In my attempt to increase the
> number of shared_buffers from the default to 65000 i was running into a
> semget error when trying to start Postgresql. After reading the
> documentation I adjusted the semaphore settings in the kernel to allow
> Postgresql to start successfully.  With this configuration running if I
> do a ipcs -u i get the following.


On my HP-585, 4xOpteron, 16G RAM, Gentoo Linux (2.6.9):

$ ipcs -u i

------ Shared Memory Status --------
segments allocated 1
pages allocated 34866
pages resident  31642
pages swapped   128
Swap performance: 0 attempts     0 successes

------ Semaphore Status --------
used arrays = 7
allocated semaphores = 119

------ Messages: Status --------
allocated queues = 0
used headers = 0
used space = 0 bytes


Did you perhaps disable spinlocks when compiling PG?

-- 
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org



view thread (25+ messages)  latest in thread

Message-ID: <b918cf3d05060613593a73a18a@mail.gmail.com>
Permalink:  ../b918cf3d05060613593a73a18a@mail.gmail.com/
Also on:    postgresql.org/message-id/b918cf3d05060613593a73a18a@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mrylander@gmail.com, mark@bowmansystems.com
  Subject: Re: Postgresql on an AMD64 machine
  In-Reply-To: <b918cf3d05060613593a73a18a@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox