Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: effective_cache_size is a real?
Date
Msg-id 4851.1153800818@sss.pgh.pa.us
Whole thread Raw
In response to effective_cache_size is a real?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: effective_cache_size is a real?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: On-disk bitmap index patch
Next
From: Tom Lane
Date:
Subject: Re: Help! - Slony-I - saving/setting/restoring GUC