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

From David Wall
Subject Re: Re: VACUUM and 24/7 database operation
Date
Msg-id 94ksgn$1tsg$1@news.tht.net
Whole thread Raw
In response to Re: Re: VACUUM and 24/7 database operation  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-general
>   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.

I think the problem is that there are log and audit files that are generally
big on inserts, with periodic cleanups after backing the data up to some
offline or other storage.  These are always being updated and are only
'select'ed when researching a customer complaint, break-in, general
troubleshooting, stats reports, etc.

David



pgsql-general by date:

Previous
From: clemens schmuck
Date:
Subject: groups a user belongs to
Next
From: KuroiNeko
Date:
Subject: Future of PQprint