Recommended VACUM timing...

From: "August Zajonc" <junk-postgre(at)aontic(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Recommended VACUM timing...
Date: 2001-03-31 00:17:07
Message-ID: 9a37m5$1b0v$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

For large tables that require a 24/7 uptime and see around 6-10 million
changes a day, how do I run VACUM without taking the database/table down.
Considering moving from MySQL, but can't quite understand how to run
PostgreSQL in a production enviroment properly.

August

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2001-03-31 01:14:50 Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Previous Message The Hermit Hacker 2001-03-30 21:48:47 Re: [HACKERS] Re: [ADMIN] User administration tool