Hi Jens,
Thanks for answer. One more question:
Can the manual VACUUM operate on database where there are long lasting
transactions?
In other words, do I need to restart the server or kill long lasting
transactions in order to allow manual VACUUM to clear old XIDs?
Regards,
Pawel
--
View this
On Fri, Mar 9, 2012 at 12:15 AM, pawel_kukawski kukis...@gmail.com wrote:
Hi Jens,
Thanks for answer. One more question:
Can the manual VACUUM operate on database where there are long lasting
transactions?
In other words, do I need to restart the server or kill long lasting
transactions
On Wednesday 07 March 2012 21:13:26 pawel_kukawski wrote:
Hi,
Do you know any real reason why the autovacuum may fail to clear old XIDs?
If it's unable to keep up.
Or may be, if there're very long running idle in transactions.
Is this highly probable ?
postmaster will shutdown to prevent
Hi,
I have a question regarding the following snippet in the official Postgres
documentation:
If for some reason autovacuum fails to clear old XIDs from a table, the
system will begin to emit warning messages like this when the database's
oldest XIDs reach ten million transactions from the