Re: Index location patch for review - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Index location patch for review
Date
Msg-id 3B9FA862.4AC3FE6B@fourpalms.org
Whole thread Raw
In response to Re: Index location patch for review  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Responses Re: Index location patch for review  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
...
> At the very least I'd like to see some information demonstrating
> how much benefit there is to this proposed patch, before we
> consider whether to adopt it.  If there's a significant performance
> benefit to splitting a PG database along the table-vs-index divide,
> then it's interesting as a short-term improvement ... but Jim didn't
> even make that assertion, let alone provide evidence to back it up.

Clearly there can be a *storage management* benefit to having control
over what gets put where, so this does not need to be justified strictly
on a performance basis.

For features like this, we will feel free to evolve them or
revolutionize them with further development, so I'm not worried about
the backward compatibility issue for cases like this.

Comments?
                   - Thomas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Index location patch for review
Next
From: Bruce Momjian
Date:
Subject: Re: Index location patch for review