From: Carl Youngblood <carl@youngbloods.org>
To: pgsql-performance@postgresql.org
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2
Date: Tue, 15 Aug 2006 12:47:54 -0600
Message-ID: <e5ed7b690608151147o7f65132do3b9d301f8b2ebc65@mail.gmail.com> (raw)
In-Reply-To: <20060815150529.GO27928@pervasive.com>
References: <e5ed7b690608092100v43590a8epdbdec7afa847c722@mail.gmail.com>
<44DAFB2B.4070307@archonet.com>
<20060815150529.GO27928@pervasive.com>
I tried setting it to 2GB and postgres wouldn't start. Didn't
investigate in much greater detail as to why it wouldn't start, but
after switching it back to 1GB it started fine.
On 8/15/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> See the recent thread about how old rules of thumb for shared_buffers
> are now completely bunk. With 4G of memory, setting shared_buffers to 2G
> could easily be reasonable. The OP really needs to test several
> different values with their actual workload and see what works best.
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: carl@youngbloods.org
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2
In-Reply-To: <e5ed7b690608151147o7f65132do3b9d301f8b2ebc65@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