On Tue, 2005-10-04 at 18:16 +0200, Zeugswetter Andreas DAZ SD wrote:
> > Another possibility is optimizing for the special case of
> > indexing on a partitioning key. In this case, index values
> > would be very localized to one table, so just storing the
> > table info on each index page (or so
Well, I never said unique, but you're correct, it's pretty undesirable
to put a global index on your partitioning key.
On Tue, Oct 04, 2005 at 06:16:21PM +0200, Zeugswetter Andreas DAZ SD wrote:
>
> > Another possibility is optimizing for the special case of
> > indexing on a partitioning key. I
On Tue, Oct 04, 2005 at 11:05:49AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Sun, Oct 02, 2005 at 09:46:07PM -0400, Tom Lane wrote:
> >> 1. A cross-table index would need to store a table OID as well as the
> >> existing block/offset information in order to tell you
> Another possibility is optimizing for the special case of
> indexing on a partitioning key. In this case, index values
> would be very localized to one table, so just storing the
> table info on each index page (or something similar) would work well.
If you have the partitioning key in the i
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Sun, Oct 02, 2005 at 09:46:07PM -0400, Tom Lane wrote:
>> 1. A cross-table index would need to store a table OID as well as the
>> existing block/offset information in order to tell you what an entry is
>> pointing at.
> Wouldn't it make more sense t
On Sun, Oct 02, 2005 at 09:46:07PM -0400, Tom Lane wrote:
> Fredrik Olsson <[EMAIL PROTECTED]> writes:
> > To allow indexes to be inherited so unique, foreign keys and such works
> > properly with inheritance has been on the todo for quite some time. I
> > thought that most probably it is a very
Fredrik Olsson <[EMAIL PROTECTED]> writes:
> To allow indexes to be inherited so unique, foreign keys and such works
> properly with inheritance has been on the todo for quite some time. I
> thought that most probably it is a very non trivial thing, perhaps
> completely rethinking how indexes ar
Hi.
To allow indexes to be inherited so unique, foreign keys and such works
properly with inheritance has been on the todo for quite some time. I
thought that most probably it is a very non trivial thing, perhaps
completely rethinking how indexes are done. Or perhaps it is not a
feature that
