Re: [GENERAL] autovacuum and transaction id wraparound

2012-03-09 Thread pawel_kukawski
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

[GENERAL] autovacuum and transaction id wraparound

2012-03-07 Thread pawel_kukawski
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

[GENERAL] invalid byte sequence for encoding UTF8: 0x00

2011-11-19 Thread pawel_kukawski
Hi, Is there any way I can store NULL character (\u) in string ? Or there is only one option that I have change every text field to bytea. Regards, Paweł -- View this message in context: