[HACKERS] rewrite HeapSatisfiesHOTAndKey
От | Alvaro Herrera |
---|---|
Тема | [HACKERS] rewrite HeapSatisfiesHOTAndKey |
Дата | |
Msg-id | 20161228232018.4hc66ndrzpz4g4wn@alvherre.pgsql обсуждение исходный текст |
Ответы |
Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey
|
Список | pgsql-hackers |
Pursuant to my comments at https://www.postgresql.org/message-id/20161223192245.hx4rbrxbrwtgwj6i@alvherre.pgsql and because of a stupid bug I found in my indirect indexes patch, I rewrote (read: removed) HeapSatisfiesHOTAndKey. The replacement function HeapDetermineModifiedColumns returns a bitmapset with a bit set for each modified column, for those columns that are listed as "interesting" -- currently that set is the ID columns, the "key" columns, and the indexed columns. The new code is much simpler, at the expense of a few bytes of additional memory used during heap_update(). All tests pass. Both WARM and indirect indexes should be able to use this infrastructure in a way that better serves them than the current HeapSatisfiesHOTAndKey (both patches modify that function in a rather ugly way). I intend to get this pushed shortly unless objections are raised. The new coding prevents stopping the check early as soon as the three result booleans could be determined. However, both patches were adding reasons to avoid stopping early anyway, so I don't think this is a significant loss. Pavan, please rebase your WARM patch on top of this and let me know how you like it. I'll post a new version of indirect indexes later this week. Comments welcome. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Вложения
В списке pgsql-hackers по дате отправления: