From:
"Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To:
Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc:
Gregory Stark <stark(at)enterprisedb(dot)com>,Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Resumable vacuum proposal and design overview
Date:
2007-03-01 15:10:32
Message-ID:
20070301151031.GI15006@nasby.net (view raw or flat )
Thread:
2007-02-26 09:21:50 from Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-26 10:20:09 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-27 02:44:28 from Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-27 03:14:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-27 16:37:45 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-27 16:49:44 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-27 17:11:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-27 17:15:52 from "Matthew T(dot) O'Connor" <matthew(at)tocr(dot)com>
2007-02-27 17:23:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-27 18:15:50 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-28 01:32:20 from Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-28 03:48:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 04:53:01 from Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-28 05:10:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 09:38:57 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-02-28 11:34:27 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-28 13:19:50 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 22:14:24 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-03-01 15:10:32 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-03-01 15:11:11 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-02-28 08:36:31 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-28 08:49:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 10:02:45 from Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-28 10:34:14 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-28 10:19:44 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-28 11:26:29 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-03-01 04:48:50 from Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
2007-03-01 06:17:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 13:28:17 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-03-01 13:52:16 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-26 10:45:56 from tomas(at)tuxteam(dot)de
2007-02-26 18:39:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 08:30:10 from tomas(at)tuxteam(dot)de
Lists:
pgsql-hackers
On Wed, Feb 28, 2007 at 10:14:24PM +0000, Heikki Linnakangas wrote:
> cache instead. In the index scan phase, it's randomly accessed, but if
> the table is clustered, it's in fact not completely random access. In
> the 2nd vacuum pass, the array is scanned sequentially again. I'm not
Only if there's only one index on the table... otherwise I'd argue that
you're much less likely to be searching the TID list incrementally.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
In response to
Responses
pgsql-hackers by date
Next :From: Heikki LinnakangasDate: 2007-03-01 15:11:11Subject : Re: Resumable vacuum proposal and design overviewPrevious :From : Hannu KrosingDate : 2007-03-01 14:54:44Subject : Re: Revitalising VACUUM FULL for 8.3
