From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | scrappy(at)hub(dot)org (The Hermit Hacker) |
Cc: | herouth(at)oumail(dot)openu(dot)ac(dot)il, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page |
Date: | 1998-02-03 18:22:22 |
Message-ID: | 199802031822.NAA17759@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
>
>
> Nobody likes to take the time to move discussions, do they? And ya, I'm
> about as guilty *sigh*
>
> Move to pgsql-hackers(at)postgresql(dot)org(dot)(dot)(dot)
>
>
> On Tue, 3 Feb 1998, Herouth Maoz wrote:
>
> > At 15:01 +0200 on 2/2/98, The Hermit Hacker wrote:
> >
> > I think the garbage collection should be separated from the statistics.
> > Garbage collection needs a write lock, statistics only a read lock. If they
> > are not done at the same time, the various tables would be locked for
> > shorter periods.
>
> Hrmmmm...good point, I think. Bruce? Vadim? When vacuum'ng a
> large table, how much time is spend 'garbage collecting' vs 'statistics'?
> I thought that 'vacuum analyze' *was* the statistics aspect of it? Where
> just 'vacuum' was only garbage collection...?
This is correct. Vacuum is fast, vacuum analyze is pretty slow. We
could separate them, I guess, and that would eliminate the write-lock
and be only a readlock.
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-02-03 18:46:22 | Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page |
Previous Message | The Hermit Hacker | 1998-02-03 17:45:05 | Re: [HACKERS] (: JDBC+(Sun ~3:pm MST) CVS :) -also question abou |