в top скачет активность по процу
cat с оригинала:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
cat orig | grep -v '^#' | grep -v '^;' |sed '/^$/d' | more
# (change requires restart)
# (change requires restart)
# (change requires restart)
max_connections = 1600 # (change requires restart)
shared_buffers = 10000MB # min 128kB
temp_buffers = 1024MB
work_mem = 512MB
maintenance_work_mem = 256MB
max_stack_depth = 2MB # min 100kB
wal_level = hot_standby # minimal, archive, or hot_standby
checkpoint_segments = 100
checkpoint_timeout = 10min
# (change requires restart)
archive_command = 'cp %p /opt/postgresql_9/xlog_archive/%f' # command to use to archive a logfile segment
# number of seconds; 0 disables
cpu_tuple_cost = 0.001
cpu_index_tuple_cost = 0.0005
effective_cache_size = 10000MB
log_destination = 'stderr'
logging_collector = on # Enable capturing of stderr and csvlog
log_directory = '../log' # directory where log files are written,
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
log_rotation_size = 100MB # Automatic rotation of logfiles will
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
# debug5
# info
log_connections = off
log_line_prefix = '%m:*:%r:**:%d:***:%u:****: ' # special values:
log_statement = 'none' # none, ddl, mod, all
autovacuum_max_workers = 100 # max number of autovacuum subprocesses
datestyle = 'iso, mdy'
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
escape_string_warning = off
с моего
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
max_connections = 100
shared_buffers = 256MB
effective_cache_size = 768MB
work_mem = 1310kB
maintenance_work_mem = 64MB
checkpoint_segments = 64
checkpoint_completion_target = 0.9
wal_buffers = 7864kB
default_statistics_target = 100
temp_buffers = 128MB
max_stack_depth = 2MB # min 100kB
wal_level = hot_standby # minimal, archive, or hot_standby
checkpoint_timeout = 10min
# (change requires restart)
archive_command = 'cp %p /opt/postgresql_9/xlog_archive/%f' # command to use to archive a logfile segment
# number of seconds; 0 disables
cpu_tuple_cost = 0.001
cpu_index_tuple_cost = 0.0005
log_destination = 'stderr'
logging_collector = on # Enable capturing of stderr and csvlog
log_directory = '../log' # directory where log files are written,
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
log_rotation_size = 100MB # Automatic rotation of logfiles will
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
# debug5
# info
log_connections = off
log_line_prefix = '%m:*:%r:**:%d:***:%u:****: ' # special values:
log_statement = 'none' # none, ddl, mod, all
###autovacuum_max_workers = 100 # max number of autovacuum subprocesses
datestyle = 'iso, mdy'
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
escape_string_warning = off
подключился ems sql managerом - там есть конфигурация сервера - и куча параметров. - где они хранятся и могли ли их накрутить?
топ:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4207 postgres 25 0 345m 17m 15m R 98.2 0.9 4:25.49 postmaster
select * from pg_stat_activity;
1.
2.
3.
4.
5.
6.
16389 | voipdb | 4024 | 10 | postgres | EMS | 91.201.21.1 | 27717 | 2014-04-16 07:06:49.657684+01 | | 2014-04-16 07:21:14.634232+01 | f | <IDLE>
16389 | voipdb | 4207 | 10 | postgres | | | -1 | 2014-04-16 07:20:06.215493+01 | 2014-04-16 07:47:22.55362+01 | 2014-04-16 07:47:22.55362+01 | f | DROP DATABASE jiradb_v4 ;
1 | template1 | 4123 | 10 | postgres | EMS | 91.201.21.1 | 27733 | 2014-04-16 07:13:32.840298+01 | | 2014-04-16 07:33:46.498962+01 | f | <IDLE>
1 | template1 | 5035 | 10 | postgres | || -1 | 2014-04-16 07:52:55.513781+01 | 2014-04-16 07:52:58.494665+01 | 2014-04-16 07:52:58.494665+01 | f | select * from pg_stat_activity;
1 | template1 | 4284 | 10 | postgres | EMS | 91.201.21.1 | 28007 | 2014-04-16 07:33:49.051944+01 | | 2014-04-16 07:35:47.371176+01 | f | <IDLE>
(5 rows)
