1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
>Routine Database Maintenance Tasks</TITLE
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="Server Administration"
16
HREF="admin.html"><LINK
18
TITLE="Character Set Support"
19
HREF="multibyte.html"><LINK
21
TITLE="Routine Vacuuming"
22
HREF="routine-vacuuming.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="Character Set Support"
80
TITLE="Backup and Restore"
89
TITLE="Routine Vacuuming"
90
HREF="routine-vacuuming.html"
105
>Chapter 23. Routine Database Maintenance Tasks</H1
111
>Table of Contents</B
115
HREF="routine-vacuuming.html"
116
>Routine Vacuuming</A
122
HREF="routine-vacuuming.html#VACUUM-BASICS"
127
HREF="routine-vacuuming.html#VACUUM-FOR-SPACE-RECOVERY"
128
>Recovering Disk Space</A
132
HREF="routine-vacuuming.html#VACUUM-FOR-STATISTICS"
133
>Updating Planner Statistics</A
137
HREF="routine-vacuuming.html#VACUUM-FOR-WRAPAROUND"
138
>Preventing Transaction ID Wraparound Failures</A
142
HREF="routine-vacuuming.html#AUTOVACUUM"
143
>The Autovacuum Daemon</A
149
HREF="routine-reindex.html"
150
>Routine Reindexing</A
154
HREF="logfile-maintenance.html"
155
>Log File Maintenance</A
163
>, like any database software, requires that certain tasks
164
be performed regularly to achieve optimum performance. The tasks
165
discussed here are <SPAN
172
are repetitive in nature and can easily be automated using standard
179
>Task Scheduler</SPAN
180
>. It is the database
181
administrator's responsibility to set up appropriate scripts, and to
182
check that they execute successfully.
185
> One obvious maintenance task is the creation of backup copies of the data on a
186
regular schedule. Without a recent backup, you have no chance of recovery
187
after a catastrophe (disk failure, fire, mistakenly dropping a critical
188
table, etc.). The backup and recovery mechanisms available in
192
> are discussed at length in
199
> The other main category of maintenance task is periodic <SPAN
203
of the database. This activity is discussed in
205
HREF="routine-vacuuming.html"
207
>. Closely related to this is updating
208
the statistics that will be used by the query planner, as discussed in
210
HREF="routine-vacuuming.html#VACUUM-FOR-STATISTICS"
215
> Another task that might need periodic attention is log file management.
216
This is discussed in <A
217
HREF="logfile-maintenance.html"
223
HREF="http://bucardo.org/wiki/Check_postgres"
227
>check_postgres</SPAN
230
is available for monitoring database health and reporting unusual
233
>check_postgres</SPAN
235
Nagios and MRTG, but can be run standalone too.
241
> is low-maintenance compared
242
to some other database management systems. Nonetheless,
243
appropriate attention to these tasks will go far towards ensuring a
244
pleasant and productive experience with the system.
252
SUMMARY="Footer navigation table"
263
HREF="multibyte.html"
281
HREF="routine-vacuuming.html"
291
>Character Set Support</TD
305
>Routine Vacuuming</TD
b'\\ No newline at end of file'