I had a problem with performance engine database, I use the server with the following specifications
1. its storage configuration?
Storage SCSI 15K RAID 5
2. how his network?
2 gigabit bonding.
3. type / behavior of applications that connect to the db?
Direct connects one segment.
4. use the machine?
DB only
5. its os? * nix or windows?
Linux
6. how large the existing data? growth?
growth 100M / day
I had a problem with memory is always exhausted, causing
database stack or very slowly, I wanted to ask how to do the tuning postgresql.conf settings for the above case, or whether there is another solution
thanks for regard
1. its storage configuration?
Storage SCSI 15K RAID 5
2. how his network?
2 gigabit bonding.
3. type / behavior of applications that connect to the db?
Direct connects one segment.
4. use the machine?
DB only
5. its os? * nix or windows?
Linux
6. how large the existing data? growth?
growth 100M / day
I had a problem with memory is always exhausted, causing
database stack or very slowly, I wanted to ask how to do the tuning postgresql.conf settings for the above case, or whether there is another solution
thanks for regard