Tom Lane wrote:
> 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?
Yep, I remembered it but forgot later. I added "typically" to the 8k
mention in all places.
>
> > #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
Nice, it is now:
#random_page_cost = 4 # units are one sequential page fetch cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073