Hi guys, I am worried about the effective_cache_size.
I run a 32-bits postgres installation on a machine with 64 bits kernel.
Should I limit effective_cache_size to a maximum of 2.5gb?
On Mon, Mar 18, 2013 at 10:53 AM, Rodrigo Barboza
rodrigombu...@gmail.com wrote:
Hi guys, I am worried about the effective_cache_size.
I run a 32-bits postgres installation on a machine with 64 bits kernel.
Should I limit effective_cache_size to a maximum of 2.5gb?
That variables refers to fs
Hello
2013/3/18 Rodrigo Barboza rodrigombu...@gmail.com:
Hi guys, I am worried about the effective_cache_size.
I run a 32-bits postgres installation on a machine with 64 bits kernel.
Should I limit effective_cache_size to a maximum of 2.5gb?
sure and probably little bit less
Regards
Pavel
Ok, now I'm lost, who is right about the limit? Rob or Pavel?
Rob, I know it should be a 64 bit, and it will be soon, but there are good
reasons for this scenario and it's ok for now.
On Mon, Mar 18, 2013 at 3:15 PM, Pavel Stehule pavel.steh...@gmail.comwrote:
Hello
2013/3/18 Rodrigo
2013/3/18 Pavel Stehule pavel.steh...@gmail.com:
Hello
2013/3/18 Rodrigo Barboza rodrigombu...@gmail.com:
Hi guys, I am worried about the effective_cache_size.
I run a 32-bits postgres installation on a machine with 64 bits kernel.
Should I limit effective_cache_size to a maximum of 2.5gb?
So setting this as half of ram, as suggested in postgres tuning webpage
should be safe?
It says it is a conservative value...
On Mon, Mar 18, 2013 at 3:18 PM, Pavel Stehule pavel.steh...@gmail.comwrote:
2013/3/18 Pavel Stehule pavel.steh...@gmail.com:
Hello
2013/3/18 Rodrigo Barboza
Rodrigo Barboza rodrigombu...@gmail.com wrote:
So setting this as half of ram, as suggested in postgres tuning
webpage should be safe?
Half of RAM is likely to be a very bad setting for any work load.
It will tend to result in the highest possible number of pages
duplicated in PostgreSQL and
On Mon, Mar 18, 2013 at 3:47 PM, Kevin Grittner kgri...@ymail.com wrote:
Rodrigo Barboza rodrigombu...@gmail.com wrote:
So setting this as half of ram, as suggested in postgres tuning
webpage should be safe?
Half of RAM is likely to be a very bad setting for any work load.
It will tend to
2013/3/18 Kevin Grittner kgri...@ymail.com:
Rodrigo Barboza rodrigombu...@gmail.com wrote:
So setting this as half of ram, as suggested in postgres tuning
webpage should be safe?
Half of RAM is likely to be a very bad setting for any work load.
It will tend to result in the highest possible