Re: [ADMIN] Vacuum stops with misleading max_fsm_pages error

2007-04-17 Thread Matthew O'Connor
Kieran Cooper, Lyris UK wrote: What is it about autovacuum that isn't working for you? Hi Matthew. I have to admit that I haven't tested full yet, but here's the scenario: When Lyris sends a mailing there is an intense amount of database activity - particularly on two tables. When I had auto

Re: [ADMIN] transactoin id wraparound problem

2006-09-06 Thread Matthew O'Connor
A PostgreSQL superuser, so yes user postgres will work just fine. Sriram Dandapani wrote: Do you mean that I login as say root and issue a vacuumdb (or do I login as a postgres user with special privileges) -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, S