Re: effective_cache_size is a real? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: effective_cache_size is a real?
Date
Msg-id 200607252309.58781.peter_e@gmx.net
Whole thread Raw
In response to Re: effective_cache_size is a real?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: effective_cache_size is a real?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Is it intentional that effective_cache_size is a real (as opposed
> > to integer)?
>
> Yes --- the planner generally does all that stuff in float arithmetic
> to avoid worrying about overflow.

Point taken, but I'm inclined to convert it to an integer anyway, 
because that will make the units support much easier.  The variable is 
only used in exactly one place anyway, so making sure the calculation 
works right should be easy.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: On-disk bitmap index patch
Next
From: "Jim C. Nasby"
Date:
Subject: Change in Pervasive's PostgreSQL strategy