From: Jose Manuel Garcia Valladolid <garcia_josval@gva.es>
To: pgsql-admin@postgresql.org
Cc: Jose Alarcon <alarcon_jos@gva.es>
Subject: WAL configuration and REINDEX
Date: Thu, 21 Sep 2006 12:40:55 +0200
Message-ID: <45126C37.6020106@gva.es> (raw)
Hello admins,
I have a PostgreSQL 8.1.4 server under Linux Red Hat with several
databases. The server is configured with WAL archiving turned on. As a
maintenance process, every night one cron job launches a backup process
to the server with
pg_dump, then the server shuts down and starts up and do a REINDEX
DATABASE to all databases to keep all tables reindexed.
After 30 days of no activity to the server (this is a DBA test server)
the amount of WAL segments is increasing at very high speed. Every
REINDEX process generates between 25 and 30 WAL segments. With this
behavior (and no activity!!) I can not maintain this amount of data to
performs future WAL backups and recovers.
Any idea to decrease the number of WAL segments generated?
Is possible to know when a table would be reindexed and to avoid dayly
REINDEX process?
Thank you.
Jose Manuel García V.
Attachments:garcia_josval.vcf (text/x-vcard, 449B) download
begin:vcard
fn;quoted-printable:Jose Manuel Garc=C3=ADa Valladolid
n;quoted-printable:Garc=C3=ADa Valladolid;Jose Manuel
org;quoted-printable;quoted-printable:Conseller=C3=ADa de Infraestructuras y Transportes;Servicio de Organizaci=C3=B3n e Inform=C3=A1tica
adr;quoted-printable;dom:;;Av. Blasco Iba=C3=B1ez 50;Valencia;VALENCIA
email;internet:garcia_josval@gva.es
title:Analista
x-mozilla-html:FALSE
url:http://www.cit.gva.es
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: garcia_josval@gva.es, alarcon_jos@gva.es
Subject: Re: WAL configuration and REINDEX
In-Reply-To: <45126C37.6020106@gva.es>
References: <45126C37.6020106@gva.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox