Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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




pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group