Re: Re: VACUUM and 24/7 database operation - Mailing list pgsql-general

From Adam Lang
Subject Re: Re: VACUUM and 24/7 database operation
Date
Msg-id 008801c08616$c95a1360$330a0a0a@6014cwpza006
Whole thread Raw
In response to VACUUM and 24/7 database operation  (Thomas.Favier@accelance.fr)
List pgsql-general
Any type of commerce or site that tracks user profiles... That's a LOT of
sites that would have a need for a enterprise level DB.

Remember, the goal is 5 nines uptime. :)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Steve Wolfe" <steve@iboats.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, January 23, 2001 3:52 PM
Subject: Re: [GENERAL] Re: VACUUM and 24/7 database operation


> > Shouldn't it be possible to build vacuum as an ongoing internal PG
> process,
> > instead of a seperate operation? How does Oracle byepass this? Must be
> some
> > way that can be implemented.
>
>   Well, here's what it comes down to:  Do you want updates to happen
> quickly, and vacuum when load is low, or do you want updates to be slow
all
> the time?  I suppose that there are some sites that can't find two minutes
> per day when updates will block (not selects), but I imagine they're very
> few.
>
> steve
>


pgsql-general by date:

Previous
From: mwaples@waples.net
Date:
Subject: postgresql user groups
Next
From: eschmid+sic@s.netic.de
Date:
Subject: Re: Postgres-Book from addison-wesley?