pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jose Manuel Garci­a 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

view thread (7+ messages)  latest in thread

Message-ID: <45126C37.6020106@gva.es>
Permalink:  ../45126C37.6020106@gva.es/
Also on:    postgresql.org/message-id/45126C37.6020106@gva.es

 · 

reply

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