Re: Too many WAL(s) despite low transaction - Mailing list pgsql-admin

From Stephen Frost
Subject Re: Too many WAL(s) despite low transaction
Date
Msg-id 20110403105251.GF4116@tamriel.snowman.net
Whole thread Raw
In response to Re: Too many WAL(s) despite low transaction  (Selva manickaraja <mavles78@gmail.com>)
Responses Re: Too many WAL(s) despite low transaction  (Selva manickaraja <mavles78@gmail.com>)
List pgsql-admin
* 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

Attachment

pgsql-admin by date:

Previous
From: Selva manickaraja
Date:
Subject: Re: Too many WAL(s) despite low transaction
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Fedora core 10: tcpip_socket = True