From:
Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
To:
Greg Stark <gsstark(at)mit(dot)edu>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>, Karl Schnaitter <karlsch(at)gmail(dot)com>
Subject:
Re: A thought on Index Organized Tables
Date:
2010-03-02 09:04:10
Message-ID:
9362e74e1003020104q14a4b3fayb7c4ae5ca8bdc510@mail.gmail.com (view raw or flat )
Thread:
2010-02-21 19:11:52 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-22 06:51:57 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-22 08:18:14 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-22 10:29:54 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-22 11:01:49 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-22 14:38:34 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-23 12:00:47 from Csaba Nagy <ncslists(at)googlemail(dot)com>
2010-02-23 04:54:13 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-02-23 05:12:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-23 06:09:14 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-02-23 06:23:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-23 06:44:48 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-02-23 13:47:42 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-23 14:58:17 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-02-23 15:11:24 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-24 12:09:16 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-23 14:49:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-23 15:08:27 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-23 15:28:06 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-24 08:20:45 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 08:30:09 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-24 08:40:52 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-24 08:46:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-24 08:53:49 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 09:24:13 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-24 09:24:31 from Karl Schnaitter <karlsch(at)gmail(dot)com>
2010-02-24 15:12:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-24 15:46:24 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-02-24 15:52:47 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-24 16:12:24 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 17:23:55 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-24 17:33:07 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-02-24 17:46:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-24 18:12:47 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-24 19:13:36 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 19:04:40 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 20:04:50 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 20:25:54 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-24 21:46:06 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 07:39:28 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 20:32:26 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-24 21:44:18 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 17:35:57 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-25 20:09:53 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 21:02:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-25 21:08:26 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-25 21:25:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-25 22:12:46 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 23:30:36 from Karl Schnaitter <karlsch(at)gmail(dot)com>
2010-02-25 23:59:26 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 00:11:54 from Karl Schnaitter <karlsch(at)gmail(dot)com>
2010-02-26 00:21:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 04:24:08 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 04:33:35 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 04:59:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 06:19:12 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 08:36:22 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 09:27:39 from Karl Schnaitter <karlsch(at)gmail(dot)com>
2010-02-26 12:57:39 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 04:20:21 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 23:45:03 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-25 23:53:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-25 23:57:42 from Karl Schnaitter <karlsch(at)gmail(dot)com>
2010-02-26 00:14:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 04:15:00 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 04:47:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 06:09:10 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 12:54:07 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-26 14:38:54 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 15:33:11 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-26 18:30:51 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 19:59:57 from Greg Stark <gsstark(at)mit(dot)edu>
2010-02-26 15:47:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 18:54:17 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 19:05:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 19:26:11 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 21:01:58 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 21:30:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 21:48:42 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-26 23:36:25 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-27 05:42:41 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-28 06:02:23 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-28 14:02:54 from Greg Stark <gsstark(at)mit(dot)edu>
2010-03-01 06:41:09 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-03-02 09:04:10 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-28 15:47:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-03-01 06:35:39 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-03-02 05:43:21 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 16:16:11 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 16:28:08 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-02-24 16:39:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-24 17:04:04 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-02-24 17:18:54 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-24 18:34:16 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 10:05:27 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-24 14:41:00 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 15:01:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-24 16:05:18 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 16:18:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-24 19:05:42 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 16:48:00 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-24 18:52:44 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-24 19:13:22 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-25 07:19:05 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 07:59:26 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-25 11:02:18 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 11:38:55 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-25 11:57:26 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 12:13:23 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-25 12:08:04 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2010-02-25 12:18:27 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-23 15:18:02 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Lists:
pgsql-hackers
>
>
> I think you have to take up a simpler project as a first project. This
> is a major overhaul of transaction information and it depends on
> understanding how a lot of different areas work -- all of which are
> very complex tricky areas to understand.
>
>
>
Greg,
I just feel the fast full index scan may not be of much value, if
we have to go to the table for visibility information. I think the feature
needs the visibility map to get completed. Please let me know, if you feel
otherwise.
Thanks,
Gokul.
In response to
pgsql-hackers by date
Next :From: Simon RiggsDate: 2010-03-02 09:48:28Subject : Re: pg_stop_backup does not completePrevious :From : Albe LaurenzDate : 2010-03-02 08:18:48Subject : WAL replay does not verify integrity
