Re: [GENERAL] Understanding postgresql logs

2013-05-30 Thread Jeff Janes
On Mon, May 27, 2013 at 6:37 AM, igivanoff wrote: > I have a PostgreSQL 9.0/9.2 which from time to time hits some memory > issues. > I know the best approach is to monitor the DB performance and activity but > in the log files I see error messages similar to: > > > TopMemoryContext: 221952 total

[GENERAL] Understanding postgresql logs

2013-05-27 Thread igivanoff
I have a PostgreSQL 9.0/9.2 which from time to time hits some memory issues. I know the best approach is to monitor the DB performance and activity but in the log files I see error messages similar to: TopMemoryContext: 221952 total in 17 blocks; 7440 free (41 chunks); 214512 used TopTransactio