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

Re: A thought on Index Organized Tables

From: Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
To: Karl Schnaitter <karlsch(at)gmail(dot)com>
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: A thought on Index Organized Tables
Date: 2010-02-26 04:20:21
Message-ID: 9362e74e1002252020j1917d6fl95dbd12b82a02a8f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
>
>>
> First of all, volatility is not the only issue. The ordering ops could also
> be incorrect, e.g., violate the transitivity property. there is no reliable
> way to determine if a function is volatile and/or incorrectly specified.
>

No it is the only issue. If you create a datatype with volatile function for
ordering ops, then you have the broken data type(the one you are referring
to). So they are one and the same.

Thanks,
Gokul.

In response to

pgsql-hackers by date

Next:From: Gokulakannan SomasundaramDate: 2010-02-26 04:24:08
Subject: Re: A thought on Index Organized Tables
Previous:From: Pavan DeolaseeDate: 2010-02-26 04:19:47
Subject: Re: visibility maps and heap_prune

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