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: Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
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:05:52
Message-ID: 2217.1267211152@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Gokulakannan Somasundaram <gokul007(at)gmail(dot)com> writes:
> But Tom, can you please explain me why that broken ordering example doesn't
> affect the current index scans.

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.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2010-02-26 19:06:51
Subject: Re: Re: Hot Standby query cancellation and Streaming Replication integration
Previous:From: Josh BerkusDate: 2010-02-26 19:02:12
Subject: Re: Hot Standby query cancellation and Streaming Replication integration

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