| From: | Jennifer Spencer <jenniferm411(at)hotmail(dot)com> |
|---|---|
| To: | <scott(dot)marlowe(at)gmail(dot)com>, <swhitney(at)journyx(dot)com> |
| Cc: | <kevin(dot)grittner(at)wicourts(dot)gov>, <scott(dot)lists(at)enterprisedb(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Catching up Production from Warm Standby aftermaintenance - Please help |
| Date: | 2009-07-07 17:40:05 |
| Message-ID: | SNT102-W30E9FD68D9B71091C9E97281280@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
You are sure that the XID wraparound is gone? That's good news. No other reasons for vacuum full on the entire database.
We could do it a table at a time if we absolutely have to do it, and that would minimize down time on the rest of the system.
-Jennifer
> > I _think_ autovacuum, somewhere around early 8.x resolves the transaction
> > wrap-around issues, but someone else should verify that.
>
> Ayup.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
_________________________________________________________________
Lauren found her dream laptop. Find the PC that’s right for you.
http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lewis Kapell | 2009-07-07 17:46:10 | Re: Catching up Production from Warm Standbyaftermaintenance - Please help |
| Previous Message | Scott Whitney | 2009-07-07 17:36:23 | Re: Catching up Production from Warm Standbyaftermaintenance - Please help |