pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Selva manickaraja <mavles78@gmail.com>
Cc: Benjamin Krajmalnik <kraj@servoyant.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Too many WAL(s) despite low transaction
Date: Sun, 3 Apr 2011 06:52:51 -0400
Message-ID: <20110403105251.GF4116@tamriel.snowman.net> (raw)
In-Reply-To: <BANLkTinsoW-XHifcX9E+wHHXaHjWgR5ytA@mail.gmail.com>
References: <20110401010336.GB4116@tamriel.snowman.net>
	<AANLkTi=U_2opbk3Kg223=++V9EfK5KGw-M-28Ec0dxCe@mail.gmail.com>
	<20110401013853.GC4116@tamriel.snowman.net>
	<AANLkTini7zev+CyTLMGFFsaZucxCR35rBsgg_Znj8F-7@mail.gmail.com>
	<20110401022209.GD4116@tamriel.snowman.net>
	<AANLkTinoAVz9qH=fV=qNxMyZnzBXsweDgGK4hQCEebZr@mail.gmail.com>
	<20110401023555.GE4116@tamriel.snowman.net>
	<AANLkTimA06euF-0t2-hZ7JifXxWsQnSmywrz97-TrBCa@mail.gmail.com>
	<F4E6A2751A2823418A21D4A160B689887B116E@fletch.stackdump.local>
	<BANLkTinsoW-XHifcX9E+wHHXaHjWgR5ytA@mail.gmail.com>

* Selva manickaraja (mavles78@gmail.com) wrote:
> Next actions to do:
> 
>    1. Implement pg_compress, or pg_lesslog, pg_clearxlogtail
>    2. Check on how well autovacuum is running and how much to tune it.

Have you tested that you can do a restore using the base backup and
WALs?  Have you made sure the database is consistent/correct after doing
such a restore?  If you change to using pg_compress or anything else,
you should be sure to repeat that testing to make sure everything works
as expected.

	Thanks,

		Stephen

Attachments:

  signature.asc (application/pgp-signature, 197B) download

view thread (16+ messages)  latest in thread

Message-ID: <20110403105251.GF4116@tamriel.snowman.net>
Permalink:  ../20110403105251.GF4116@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20110403105251.GF4116@tamriel.snowman.net

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sfrost@snowman.net, mavles78@gmail.com, kraj@servoyant.com
  Subject: Re: Too many WAL(s) despite low transaction
  In-Reply-To: <20110403105251.GF4116@tamriel.snowman.net>

* 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