| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
| Cc: | "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>, "Tino Schwarze" <postgresql(at)tisc(dot)de>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Configuring Shared Buffers |
| Date: | 2008-07-01 02:08:39 |
| Message-ID: | dcc563d10806301908m5d90b8beqa60b8c53efc0ed7f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Jun 30, 2008 at 7:09 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Rafael Domiciano escribió:
>> The Postgres version is 8.3.3 and I am using Fedora Core 8.
>> I have in the actual server around 70 connections the same time. I am
>> assigning for this 100.
>
> 100 MB? That's not very much either. You can probably get a hefty
> performance boost by upping it a lot more (depending on whether the
> machine is doing something else, or Postgres is the only service running
> on it.)
I think he was talking about max connections.
As for shared buffers, I'd start out at about 25% main memory for
8.3.3 and test that. Also, he should be looking at his setting for
work_mem
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-07-01 02:38:46 | Re: Configuring Shared Buffers |
| Previous Message | Alvaro Herrera | 2008-07-01 01:09:27 | Re: Configuring Shared Buffers |