Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Error while starting postgreSQL service

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bebarta, Simanchala" <Simanchala(dot)Bebarta(at)in(dot)unisys(dot)com>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] Error while starting postgreSQL service
Date: 2007-11-19 16:58:52
Message-ID: dcc563d10711190858v534db481u3b84396a8b578ce1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On Nov 19, 2007 4:15 AM, Bebarta, Simanchala
<Simanchala(dot)Bebarta(at)in(dot)unisys(dot)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.

In response to

pgsql-admin by date

Next:From: Magnus HaganderDate: 2007-11-19 17:20:20
Subject: Re: [GENERAL] Error while starting postgreSQL service
Previous:From: Richard HuxtonDate: 2007-11-19 10:33:53
Subject: Re: [GENERAL] Error while starting postgreSQL service

pgsql-general by date

Next:From: Dragan MaticDate: 2007-11-19 17:03:36
Subject: Re: Timestamp comparison with string in some special cases
Previous:From: Scott MarloweDate: 2007-11-19 16:47:34
Subject: Re: Substitute column in SELECT with static value? (Crosstab problem?)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group