VACUUM FULL needed sometimes to prevent transaction ID wraparound?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-performance@xxxxxxxxxxxxxx
- Subject: VACUUM FULL needed sometimes to prevent transaction ID wraparound?
- From: Marinos Yannikos <mjy@xxxxxxxxxxx>
- Date: Tue, 22 Aug 2006 20:10:49 +0200
- User-agent: Thunderbird 1.5.0.5 (Windows/20060719)
Hello,
we're looking into the reason why we are getting warnings about
transaction ID wraparound despite a daily "vaccumdb -qaz". Someone is
claiming that VACUUM without FULL cannot reassign XIDs properly when
max_fsm_pages was set too low (it says so here too, but this is rather
old: http://www.varlena.com/GeneralBits/Tidbits/perf.html#maxfsmp). Is
this true, or do we have a different issue here? We're using 8.1.3 with
a database generated on 8.1.3 (i.e. not migrated from 7.x or anything
like that).
Thanks,
Marinos
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]