Re: Tuning

From: "Mischa Sandberg" <mischas(at)ca(dot)sophos(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Tuning
Date: 2007-01-31 17:25:12
Message-ID: DCED23B198FFA144A0398D9CE4C4A6AD011108AC@ca-exchange.activestate.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-
> owner(at)postgresql(dot)org] On Behalf Of John Parnefjord
> Sent: Tuesday, January 30, 2007 2:05 AM
> Subject: Re: [PERFORM] Tuning

> EnterpriseDB advocates: 250 KB + 8.2 KB * shared_buffers + 14.2 kB *
> max_connections up to infinity
> [http://www.enterprisedb.com/documentation/kernel-resources.html]

... + 8.1KB * wal_buffers + 6 * max_fsm_pages + 65 * max_fsm_relations.
Okay, maybe getting pedantic; but if you're going to cite the ~256KB
const over head ... :-)

In response to

  • Re: Tuning at 2007-01-30 10:05:03 from John Parnefjord

Responses

  • Re: Tuning at 2007-02-06 10:21:41 from Harald Armin Massa

Browse pgsql-performance by date

  From Date Subject
Next Message Abu Mushayeed 2007-02-01 00:57:38 Slow update
Previous Message Sidar López Cruz 2007-01-31 15:28:05 Re: Very slow queries