System lockup
От | DeJuan Jackson |
---|---|
Тема | System lockup |
Дата | |
Msg-id | 3E84776C.5050705@speedfc.com обсуждение исходный текст |
Ответы |
Re: System lockup
|
Список | pgsql-general |
Two systems both Red Hat running Postgres 7.3.2 Postgres (installed from tar) data is 1.8G total space (half of which is static data touched once a night when I vacuum), there are web pages (Apache 2.0.44, PHP 4.3.2), and scripts (also PHP 4.3.2) intereacting with both boxes continuously. The only postgres.conf settings that are moved from default are: tcpip_socket = true max_connections = 75 shared_buffers = 150 log_connections = true log_pid = false log_statement = true log_duration = true log_timestamp = true stats_command_string = true stats_row_level = true stats_block_level = true System 1: Red Hat Linux release 8.0 (Psyche) [default server config without X] kernel version 2.4.18 total system RAM 1.5G only two services running on the system Postgres and sshd OpenSSL 0.9.6b [engine] 9 Jul 2001 output from vmstat after 20 hours of uptime (look at the memory): procs memory swap io system r b w swpd free buff cache si so bi bo in cs us 0 0 0 0 46080 60348 1382608 0 0 10 6 265 11 0 System 2: Red Hat Linux release 7.1 (Seawolf) [default server config without X] kernel version 2.4.2 total system RAM 1G only three services running on the system Postgres, sshd, and sendmail (hadn't turned it off yet) OpenSSL 0.9.6b [engine] 9 Jul 2001 output from vmstat after 20 hours of uptime (look at the memory): procs memory swap io system r b w swpd free buff cache si so bi bo in cs us 0 0 0 0 5988 25544 915880 0 0 3 4 58 34 2 I've been running postgres for years on Red Hat systems without a hitch, but I can't for the life of me figure this one out. So, any help would be appreciated.
В списке pgsql-general по дате отправления: