Skip site navigation (1) Skip section navigation (2)

Re: A thought on Index Organized Tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karl Schnaitter <karlsch(at)gmail(dot)com>
Cc: Gokulakannan Somasundaram <gokul007(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 00:21:04
Message-ID: 9818.1267143664@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Karl Schnaitter <karlsch(at)gmail(dot)com> writes:
> Of course, PG can't "support" indexing with incorrect functions. However,
> it's worthwhile to guard against too much damage being done if the user's
> function has a bug. Maybe I'm wrong? Maybe an index tuple with a dangling
> pointer is actually harmless?

No, it's far from harmless.  As soon as that heap TID gets filled with
an unrelated tuple, you run the risk of indexscans alighting on and
perhaps modifying the wrong tuple.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2010-02-26 00:44:37
Subject: Re: trouble with to_char('L')
Previous:From: Bruce MomjianDate: 2010-02-26 00:20:58
Subject: Re: psql with "Function Type" in \df

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group