Hello, I am running django on heavy load server, and multiple times a week I have my postgres crashing due to high server load. When I get TOP, I see many many postmasters running at the same time, until I get 'Too many connections' postgres failiour error from postmaster emailed to me from django.
How many postmaster instances should be running at once? There isn't much happening differently in terms of load on the days that the server is crashing to the days that the server is working smoothly. Here is my top: Tasks: 665 total, 10 running, 655 sleeping, 0 stopped, 0 zombie Cpu(s): 14.9% us, 16.7% sy, 0.0% ni, 0.0% id, 68.4% wa, 0.0% hi, 0.0% si Mem: 2074932k total, 2051572k used, 23360k free, 2736k buffers Swap: 2096440k total, 1844448k used, 251992k free, 102968k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 6420 postgres 15 0 26912 11m 10m R 3.6 0.6 0:00.11 postmaster 6565 postgres 16 0 26912 11m 10m S 3.6 0.6 0:00.12 postmaster 6707 postgres 15 0 26912 11m 10m S 3.3 0.6 0:00.10 postmaster 6715 postgres 15 0 26912 11m 10m S 3.3 0.6 0:00.11 postmaster 6765 postgres 15 0 26912 11m 10m S 3.3 0.6 0:00.11 postmaster 6147 postgres 15 0 26912 11m 10m R 3.0 0.6 0:00.15 postmaster 6311 postgres 15 0 26904 11m 10m R 3.0 0.6 0:00.10 postmaster 6551 postgres 15 0 26912 11m 10m R 3.0 0.6 0:00.09 postmaster 6803 postgres 16 0 26912 11m 10m R 3.0 0.6 0:00.09 postmaster 6255 postgres 15 0 26904 11m 10m R 2.6 0.6 0:00.14 postmaster 6357 postgres 15 0 26912 11m 10m R 2.6 0.6 0:00.11 postmaster 6455 postgres 15 0 26912 11m 10m S 2.6 0.6 0:00.10 postmaster 6457 postgres 15 0 26912 11m 10m S 2.6 0.6 0:00.11 postmaster 6276 postgres 15 0 26912 11m 10m S 2.3 0.6 0:00.10 postmaster 6475 postgres 15 0 26912 11m 10m R 2.3 0.6 0:00.11 postmaster 6868 postgres 15 0 26912 11m 10m S 2.3 0.6 0:00.07 postmaster 6891 postgres 15 0 26912 11m 10m S 1.3 0.6 0:00.19 postmaster Thanks, Sia --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
