Re: Too many WAL(s) despite low transaction

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Selva manickaraja <mavles78(at)gmail(dot)com>
Cc: Benjamin Krajmalnik <kraj(at)servoyant(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Too many WAL(s) despite low transaction
Date: 2011-04-03 10:52:51
Message-ID: 20110403105251.GF4116@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* Selva manickaraja (mavles78(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2011-04-03 21:57:50 Re: Fedora core 10: tcpip_socket = True
Previous Message Selva manickaraja 2011-04-03 03:53:37 Re: Too many WAL(s) despite low transaction