pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Bebarta, Simanchala <Simanchala.Bebarta@in.unisys.com>
Cc: Richard Huxton <dev@archonet.com>
Cc: PG-General Mailing List <pgsql-general@postgresql.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Error while starting postgreSQL service
Date: Mon, 19 Nov 2007 10:58:52 -0600
Message-ID: <dcc563d10711190858v534db481u3b84396a8b578ce1@mail.gmail.com> (raw)
In-Reply-To: <D566E8CF3538B54D95B925CB69CB4D2A08DAAC33@inblr-exch1.eu.uis.unisys.com>
References: <D566E8CF3538B54D95B925CB69CB4D2A08DAA8D0@inblr-exch1.eu.uis.unisys.com>
	<47415B2B.1030007@archonet.com>
	<D566E8CF3538B54D95B925CB69CB4D2A08DAAAED@inblr-exch1.eu.uis.unisys.com>
	<474160F0.4060003@archonet.com>
	<D566E8CF3538B54D95B925CB69CB4D2A08DAAC33@inblr-exch1.eu.uis.unisys.com>

On Nov 19, 2007 4:15 AM, Bebarta, Simanchala
<Simanchala.Bebarta@in.unisys.com> wrote:
> Yes, when I set the value to 1300 MB, everything goes fine. Any value
> higher than this value does not allow me to start the service.

Please don't top post.

Anyway, are you sure that increasing shared_buffers that high is
helping?  There's some evidence that windows pgsql can't use
shared_buffer settings that high efficiently.  Have you tested
shared_buffer settings starting low and working you way up and seen a
steady increase in performance?  Or are you just guessing that larger
shared_buffer = better performance?

I'm guessing that it's a limitation of windows and pgsql that you're
running into.  If you want to run a large memory postgresql database
server with lots of load, I highly recommend using unix as the
underlying OS, as pgsql is far better tested and supported there.



view thread (9+ messages)  latest in thread

Message-ID: <dcc563d10711190858v534db481u3b84396a8b578ce1@mail.gmail.com>
Permalink:  ../dcc563d10711190858v534db481u3b84396a8b578ce1@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10711190858v534db481u3b84396a8b578ce1@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-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, Simanchala.Bebarta@in.unisys.com, dev@archonet.com, pgsql-general@postgresql.org
  Subject: Re: [GENERAL] Error while starting postgreSQL service
  In-Reply-To: <dcc563d10711190858v534db481u3b84396a8b578ce1@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