Re: pg_autovacuum entries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If I were to use autovacuum on 8.1 , and If I specify the "ignore'
tables in pg_autovacuum,

1. will the XID wraparound counter be reset after autovacuum finishes
2. If some of the ignore tables are never dropped or deleted in the
future...how do the transaction semantics work with the rows in these
tables (this is not likely to happen..but I am curious to know how
transaction semantics work with the data in these tables)

On Sun, Nov 1, 2009 at 9:56 AM, Alvaro Herrera
<alvherre@xxxxxxxxxxxxxxxxx> wrote:
> Anj Adu escribió:
>> My goal is to reset the XID wraparound counter by performing vacuumdb
>> (autovacuum is not an option for my for various reasons)
>
> Note that if you are on 8.1 (I can't recall) you need to vacuum the
> whole database in a single command for Xid wraparound.  Only on 8.2 and
> higher you can get away with doing it one table at a time.
>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux