On Fri, 2006-07-21 at 15:49, Erik Jones wrote:
> Scott Marlowe wrote:
> >
> > I'd use regular cronned vacuums on the tables that you know grown a lot
> > (or just hit the whole db and not worry about it) and run occasional
> > vacuum verbose / vacuum full verbose by hand to see if you have problems
Scott Marlowe wrote:
On Fri, 2006-07-21 at 15:49, Erik Jones wrote:
Scott Marlowe wrote:
I'd use regular cronned vacuums on the tables that you know grown a lot
(or just hit the whole db and not worry about it) and run occasional
vacuum verbose / vacuum full verbose by hand to see if yo
Scott Marlowe wrote:
On Fri, 2006-07-21 at 11:40, Erik Jones wrote:
Scott Marlowe wrote:
On Fri, 2006-07-21 at 10:13, Erik Jones wrote:
Hello, I was wondering if someone could enlighten me as to the impact to
the entire database of running VACUUM FULL against a single table.
On Fri, 2006-07-21 at 11:40, Erik Jones wrote:
> Scott Marlowe wrote:
> > On Fri, 2006-07-21 at 10:13, Erik Jones wrote:
> >
> >> Hello, I was wondering if someone could enlighten me as to the impact to
> >> the entire database of running VACUUM FULL against a single table. The
> >> reason I
On Fri, 21 Jul 2006 11:40:32 -0500
Erik Jones <[EMAIL PROTECTED]> wrote:
> No!!! The table is filled and entries are deleted one at a time, or in
> groups, but definitely not all at once.So, then what is the
> difference between scheduling regular vacuum on specific tables v.
> scheduling
On Fri, 21 Jul 2006 10:35:17 -0500
Erik Jones <[EMAIL PROTECTED]> wrote:
> Csaba Nagy wrote:
[snip]
> That is an excellent idea, however, what are the effects of CLUSTER on
> empty tables? Considering that most of our queue tables sit empty until
> their used, our main concern is keep the disk
Scott Marlowe wrote:
On Fri, 2006-07-21 at 10:13, Erik Jones wrote:
Hello, I was wondering if someone could enlighten me as to the impact to
the entire database of running VACUUM FULL against a single table. The
reason I ask is that at company we work for we have a very large number
of que
On Fri, 2006-07-21 at 10:13, Erik Jones wrote:
> Hello, I was wondering if someone could enlighten me as to the impact to
> the entire database of running VACUUM FULL against a single table. The
> reason I ask is that at company we work for we have a very large number
> of queue type tables tha
Csaba Nagy wrote:
Erik,
On Fri, 2006-07-21 at 17:13, Erik Jones wrote:
Hello, I was wondering if someone could enlighten me as to the impact to
the entire database of running VACUUM FULL against a single table. The
reason I ask is that at company we work for we have a very large number
of
Erik,
On Fri, 2006-07-21 at 17:13, Erik Jones wrote:
> Hello, I was wondering if someone could enlighten me as to the impact to
> the entire database of running VACUUM FULL against a single table. The
> reason I ask is that at company we work for we have a very large number
> of queue type tab
Hello, I was wondering if someone could enlighten me as to the impact to
the entire database of running VACUUM FULL against a single table. The
reason I ask is that at company we work for we have a very large number
of queue type tables that fill up and empty out on a regular basis, on
the ave
11 matches
Mail list logo
