Re: size of units in postgresql.conf - Mailing list pgsql-general

From Tom Lane
Subject Re: size of units in postgresql.conf
Date
Msg-id 14960.1030408566@sss.pgh.pa.us
Whole thread Raw
In response to Re: size of units in postgresql.conf  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: size of units in postgresql.conf
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Here is the 7.3 postgresql.conf file, where I have added units to the
> file.

Aren't these misleading if one is using nonstandard BLCKSZ?

> #shared_buffers = 64        # 2*max_connections, min 16, 8K each
> #wal_buffers = 8        # min 4, 8K each
> #effective_cache_size = 1000    # 8K each


These could usefully be labeled as "unit is cost of a sequential page
fetch":

> #random_page_cost = 4
> #cpu_tuple_cost = 0.01
> #cpu_index_tuple_cost = 0.001
> #cpu_operator_cost = 0.0025

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Solved! MacOS X and external functions
Next
From: Alvaro Herrera
Date:
Subject: Re: size of units in postgresql.conf