Postgres Pro
Downloads
Home   >   mailing lists

Re: Tuning - Mailing list pgsql-performance

From Mischa Sandberg
Subject Re: Tuning
Date
Msg-id DCED23B198FFA144A0398D9CE4C4A6AD011108AC@ca-exchange.activestate.ca
Whole thread Raw
In response to Re: Tuning  ("John Parnefjord" <John.Parnefjord@kib.ki.se>)
Responses Re: Tuning
List pgsql-performance
Tree view 
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-
> owner@postgresql.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 ... :-)

pgsql-performance by date:

Previous
From: Mark Stosberg
Date:
Subject: Re: optimizing a geo_distance() proximity query (example and benchmark)
Next
From: Bill Howe
Date:
Subject: index scan through a subquery