Euler,
Sem replicação.
name | current_setting
| source | sourcefile
| sourceline
---------------------------------+----------------------------------------------+----------------------+-----------------------------------------+------------
application_name | psql
| client | |
archive_command | cp /var/lib/pgsql/9.3/data/%p
/backup/wal/%f | configuration file |
/var/lib/pgsql/9.3/data/postgresql.conf | 196
archive_mode | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
194
archive_timeout | 10min
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
200
autovacuum_analyze_scale_factor | 0.02
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
467
autovacuum_max_workers | 9
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
459
autovacuum_vacuum_scale_factor | 0.05
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
466
bgwriter_lru_maxpages | 150
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
149
checkpoint_segments | 25
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
186
checkpoint_timeout | 10min
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
187
client_encoding | UTF8
| client | |
data_checksums | off
| override | |
DateStyle | ISO, MDY
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
511
default_statistics_target | 1000
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
286
default_text_search_config | pg_catalog.english
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
533
effective_cache_size | 60GB
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
272
lc_collate | en_US.UTF-8
| override | |
lc_ctype | en_US.UTF-8
| override | |
lc_messages | en_US.UTF-8
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
526
lc_monetary | en_US.UTF-8
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
528
lc_numeric | en_US.UTF-8
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
529
lc_time | en_US.UTF-8
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
530
listen_addresses | *
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
59
lo_compat_privileges | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
567
log_autovacuum_min_duration | 0
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
455
log_checkpoints | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
392
log_connections | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
393
log_destination | stderr
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
300
log_directory | pg_log
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
312
log_disconnections | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
394
log_filename | postgresql-%Y%m%d.log
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
314
log_line_prefix | %t [%p]: [%l-1] db=%d,user=%u@%r %x:%v
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
398
log_lock_waits | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
418
log_min_duration_statement | 1s
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
380
log_rotation_age | 1d
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
326
log_rotation_size | 100MB
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
328
log_statement | ddl
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
419
log_temp_files | 0
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
420
log_timezone | America/Recife
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
423
log_truncate_on_rotation | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
318
logging_collector | on
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
306
maintenance_work_mem | 1400MB
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
124
max_connections | 800
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
64
max_prepared_transactions | 2000
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
117
max_stack_depth | 2MB
| environment variable | |
max_wal_senders | 10
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
212
port | 5432
| command line | |
search_path |
"$user",public,core,acl,client,criminal,jt | configuration file |
/var/lib/pgsql/9.3/data/postgresql.conf | 487
server_encoding | UTF8
| override | |
server_version | 9.3.4
| default | |
shared_buffers | 6GB
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
114
statement_timeout | 0
| user | |
superuser_reserved_connections | 20
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
67
tcp_keepalives_count | 0
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
104
tcp_keepalives_idle | 0
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
100
tcp_keepalives_interval | 0
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
102
temp_buffers | 80MB
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
116
TimeZone | America/Recife
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
513
transaction_deferrable | off
| override | |
transaction_isolation | read committed
| override | |
transaction_read_only | off
| override | |
wal_buffers | 16MB
| override | |
wal_level | archive
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
163
wal_sync_method | fdatasync
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
169
work_mem | 80MB
| configuration file | /var/lib/pgsql/9.3/data/postgresql.conf |
123
(65 rows)
Apesar de ter resolvido o problema dando uma porrada de checkpoints, não
acho que esse seja um comportamento "normal" para o banco
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
