Re: [QUESTIONS] MySQL benchmark page
Marc G. Fournier <scrappy@hub.org>
From: The Hermit Hacker <scrappy@hub.org>
To: Herouth Maoz <herouth@oumail.openu.ac.il>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-02-03T12:10:16Z
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@postgresql.org... 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...?