Re: Physical append-only tables
От | Magnus Hagander |
---|---|
Тема | Re: Physical append-only tables |
Дата | |
Msg-id | CABUevEx0JcJxjfmmPy=q3F7f2QLg234=U1KXkyRBrup5tt9z2g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Physical append-only tables (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Mon, Nov 14, 2016 at 3:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Magnus Hagander <magnus@hagander.net> writes:
> What I'm talking about is something that would be a lot simpler than
> auto-clustering. I'm not even talking about trying to detect if the row was
> about to go into the right place -- this might be expensive and certainly
> more complicated. I'm only talking about a simple case where we *never* put
> anything anywhere other than at the end of the table, period. That should
> make the check both cheap and simple.
It also makes it so much of a corner case that even a cheap check could be
a net performance degradation, especially for people whose usage pattern
doesn't match this.
I agree that it definitely solves just one problem. But it seems to be a fairly common problem, particularly for users of BRIN users.
Full auto-clustering would cover many more usecases, but would also be a lot more expensive to maintain.
В списке pgsql-hackers по дате отправления: