Didik Prasetyo <prasetyodidik62@xxxxxxxxx> wrote: > 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 I'm not entirely sure what problem you are seeing. If you post again, please show your version and configuration. An easy way to do this is to run the query on this page and pastte the output into your post: http://wiki.postgresql.org/wiki/Server_Configuration For general tuning advice you should read this page: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server If there is a particular query which is causing problems, please post detail related to that query. See this page: http://wiki.postgresql.org/wiki/SlowQueryQuestions If it is some other sort of problem, it helps to provide more detail and to copy and paste any error messages: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems A couple general points which might apply: (1) RAID 5 is OK for reads, but is slow for random writes in heavy loads. This is mitigated somewhat by having a good RAID controller with a battery backed RAM cache configured for write-back. (2) You need to be running autovacuum and you need to avoid long-running transactions (including those which show as "idle in transaction") to avoid bloat, which can cause your database to grow rapidly. I hope this helps, -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
