Michael Stone writes:
> On Tue, May 15, 2007 at 06:43:50PM +0200, Guillaume Cottenceau wrote:
> >patch - basically, I think the documentation under estimates (or
> >sometimes misses) the benefit of VACUUM FULL for scans, and the
> >needs of VACUUM FULL if the routine VACUUM hasn't been done
> >pr
What do you mean by "softupdates?" Is that a parameter in what I am guessing
is the conf file?
Yudhvir
On 5/15/07, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
I'm guessing you're seeing the affect of softupdates. With those enabled
it can take some time before the space freed by a delete will act
Cool!
Now we can point people to your faq instead of repeating the "dd" test
instructions. Thanks for normalizing this out of the list :-)
- Luke
On 5/15/07 8:55 PM, "Greg Smith" <[EMAIL PROTECTED]> wrote:
> I've been taking notes on what people ask about on this list, mixed that
> up with wo
On Wed, May 16, 2007 at 09:41:46AM +0200, Guillaume Cottenceau wrote:
> Michael Stone writes:
>
> > On Tue, May 15, 2007 at 06:43:50PM +0200, Guillaume Cottenceau wrote:
> > >patch - basically, I think the documentation under estimates (or
> > >sometimes misses) the benefit of VACUUM FULL for sca
No, it's part of FreeBSD's UFS. google FreeBSD softupdates and you
should get plenty of info.
As I said, it's probably not worth worrying about.
On Wed, May 16, 2007 at 08:21:23AM -0700, Y Sidhu wrote:
> What do you mean by "softupdates?" Is that a parameter in what I am guessing
> is the conf fi
"Jim C. Nasby" writes:
> On Wed, May 16, 2007 at 09:41:46AM +0200, Guillaume Cottenceau wrote:
[...]
> > Come on, I don't suggest to remove several bold warnings about
> > it, the best one being "Therefore, frequently using VACUUM FULL
> > can have an extremely negative effect on the performanc
Guillaume Cottenceau wrote:
> "Jim C. Nasby" writes:
>
> > On Wed, May 16, 2007 at 09:41:46AM +0200, Guillaume Cottenceau wrote:
>
> [...]
>
> > > Come on, I don't suggest to remove several bold warnings about
> > > it, the best one being "Therefore, frequently using VACUUM FULL
> > > can have
On Wed, May 16, 2007 at 12:09:26PM -0400, Alvaro Herrera wrote:
> Guillaume Cottenceau wrote:
> > "Jim C. Nasby" writes:
> >
> > > On Wed, May 16, 2007 at 09:41:46AM +0200, Guillaume Cottenceau wrote:
> >
> > [...]
> >
> > > > Come on, I don't suggest to remove several bold warnings about
> > >
On Wed, May 16, 2007 at 12:09:26PM -0400, Alvaro Herrera wrote:
Maybe, but we should also mention that CLUSTER is a likely faster
workaround.
Unless, of course, you don't particularly care about the order of the
items in your table; you might end up wasting vastly more time rewriting
tables d
[EMAIL PROTECTED] (Michael Stone) writes:
> On Wed, May 16, 2007 at 12:09:26PM -0400, Alvaro Herrera wrote:
>>Maybe, but we should also mention that CLUSTER is a likely faster
>>workaround.
>
> Unless, of course, you don't particularly care about the order of
> the items in your table; you might en
On Wed, May 16, 2007 at 03:34:42PM -0400, Chris Browne wrote:
[EMAIL PROTECTED] (Michael Stone) writes:
Unless, of course, you don't particularly care about the order of
the items in your table; you might end up wasting vastly more time
rewriting tables due to unnecessary clustering than for ful
Michael Stone wrote:
> On Wed, May 16, 2007 at 03:34:42PM -0400, Chris Browne wrote:
> >[EMAIL PROTECTED] (Michael Stone) writes:
> >>Unless, of course, you don't particularly care about the order of
> >>the items in your table; you might end up wasting vastly more time
> >>rewriting tables due to
Michael Stone <[EMAIL PROTECTED]> writes:
> On Wed, May 16, 2007 at 03:34:42PM -0400, Chris Browne wrote:
>> If CLUSTER is faster than VACUUM FULL (and if it isn't, in all cases,
>> it *frequently* is, and probably will be, nearly always, soon), then
>> it's a faster workaround.
> Cluster reorders
Jim C. Nasby wrote:
No, it's part of FreeBSD's UFS. google FreeBSD softupdates and you
should get plenty of info.
As I said, it's probably not worth worrying about.
On Wed, May 16, 2007 at 08:21:23AM -0700, Y Sidhu wrote:
What do you mean by "softupdates?" Is that a parameter in what I am gues
14 matches
Mail list logo
