From:
Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Greg Stark <gsstark(at)mit(dot)edu>, Karl Schnaitter <karlsch(at)gmail(dot)com>, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: A thought on Index Organized Tables
Date:
2010-02-26 19:26:11
Message-ID:
9362e74e1002261126p10cb63c8j8795a561b94e7287@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
> It does. The point is that the system is set up to limit the bad
> consequences. You might (will) get wrong query answers, but the
> heap data won't get corrupted.
>
>
Again Tom, if there is an update based on index scan, then it takes the
tupleid and updates the wrong heap data right?
The only difference between normal index and thick index is to reach back to
the same index tuple to update the snapshot. How will that corrupt the heap
data? Did you intend to say that it corrupts the index data?
Thanks,
Gokul.
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-02-26 19:57:56Subject : Re: Avoiding bad prepared-statement plans. Previous :From : Mark MielkeDate : 2010-02-26 19:23:22Subject : Re: Avoiding bad prepared-statement plans.
