Why is my pg_xlog directory so huge?

Поиск
Список
Период
Сортировка
Искать
От
Niels Kristian Schjødt
Тема
Why is my pg_xlog directory so huge?
Дата
Msg-id
02E032A0-7E7A-4CB3-9C76-5739B05660D5@autouncle.com
Список
Дерево обсуждения
Why is my pg_xlog directory so huge? Niels Kristian Schjødt <nielskristian@autouncle.com>
Re: Why is my pg_xlog directory so huge? Magnus Hagander <magnus@hagander.net>
Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt <nielskristian@autouncle.com>
Re: Why is my pg_xlog directory so huge? Magnus Hagander <magnus@hagander.net>
Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt <nielskristian@autouncle.com>
After installing my new server I just discovered something that doesn't seem right:

sudo du -h /var/lib/postgresql/9.2/main

4.0K	/var/lib/postgresql/9.2/main/pg_snapshots
4.0K	/var/lib/postgresql/9.2/main/pg_serial
4.0K	/var/lib/postgresql/9.2/main/pg_tblspc
29M	/var/lib/postgresql/9.2/main/pg_clog
6.8G	/var/lib/postgresql/9.2/main/pg_log
104K	/var/lib/postgresql/9.2/main/pg_stat_tmp
81G	/var/lib/postgresql/9.2/main/base/27132
6.1M	/var/lib/postgresql/9.2/main/base/12040
4.0K	/var/lib/postgresql/9.2/main/base/pgsql_tmp
6.0M	/var/lib/postgresql/9.2/main/base/12035
6.0M	/var/lib/postgresql/9.2/main/base/1
81G	/var/lib/postgresql/9.2/main/base
80K	/var/lib/postgresql/9.2/main/pg_multixact/members
108K	/var/lib/postgresql/9.2/main/pg_multixact/offsets
192K	/var/lib/postgresql/9.2/main/pg_multixact
12K	/var/lib/postgresql/9.2/main/pg_notify
4.0K	/var/lib/postgresql/9.2/main/pg_twophase
160K	/var/lib/postgresql/9.2/main/pg_subtrans
752K	/var/lib/postgresql/9.2/main/pg_xlog/archive_status
202G	/var/lib/postgresql/9.2/main/pg_xlog
496K	/var/lib/postgresql/9.2/main/global
289G	/var/lib/postgresql/9.2/main

As you can see the pg_xlog folder is 202G, which is more than my entire database - this seems wrong to me, however I have no clue why this would happen.

In short, this is my postgresql.conf

data_directory = '/var/lib/postgresql/9.2/main'         # use data in another directory
hba_file = '/etc/postgresql/9.2/main/pg_hba.conf'       # host-based authentication file
ident_file = '/etc/postgresql/9.2/main/pg_ident.conf'   # ident configuration file
external_pid_file = '/var/run/postgresql/9.2-main.pid'          # write an extra PID file
listen_addresses = '192.168.0.4, localhost'                  # what IP address(es) to listen on;
port = 5432                             # (change requires restart)
max_connections = 300                   # (change requires restart)
unix_socket_directory = '/var/run/postgresql'           # (change requires restart)
wal_level = hot_standby                 # minimal, archive, or hot_standby
synchronous_commit = on                # synchronization level; on, off, or local
checkpoint_segments = 100               # in logfile segments, min 1, 16MB each
checkpoint_timeout = 10min             # range 30s-1h
checkpoint_completion_target = 0.9     # checkpoint target duration, 0.0 - 1.0
archive_mode = on               # allows archiving to be done
archive_command = 'rsync -a %p postgres@192.168.0.2:/var/lib/postgresql/9.2/wals/%f 
В списке pgsql-performance по дате отправления
От: Mark Kirkwood
Дата:
Сообщение: Re: New server setup
От: Magnus Hagander
Дата:
FAQ