Postgres Pro
Downloads
Home   >   mailing lists

How to avoid generation huge pg_xlog files during VACUUM , REINDEX maintenance task. - Mailing list pgsql-admin

From Shrinivas Devarkonda
Subject How to avoid generation huge pg_xlog files during VACUUM , REINDEX maintenance task.
Date
Msg-id CAJavUp1-aStB6yVg_BMWaS+4j=2TPqOppKM0CLCQnA9F24hCAw@mail.gmail.com
Whole thread Raw
Responses Re: How to avoid generation huge pg_xlog files during VACUUM , REINDEX maintenance task.  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
Hi All,

We have a High transactional Database with Streamline Replication in place across two Data Centers with the dedicated leased line. The SR works awesome all time.

We do vacuum+reindex of few imp high transactional tables (not an entire database) which generates many pg_xlog files indeed creates Huge spike of Data transfer between two networks and burst the bandwidth only during this time.

Can we avoid the generating pg_xlog files for vacuum + reindex ?  Are any other solutions to it ?  Our vacuum + reindex is very very minimal and based on dead rows stats.

PG version :  9.0.4 ( on 64 bit OS).


Thanks,
Shrinivas Devarkonda.



pgsql-admin by date:

Previous
From: David G Johnston
Date:
Subject: Re:
Next
From: Ray Stell
Date:
Subject: 9.0.15 WAL mis-replay status?