Major Feature Interactions
От | Simon Riggs |
---|---|
Тема | Major Feature Interactions |
Дата | |
Msg-id | 1172668229.3760.958.camel@silverbirch.site обсуждение исходный текст |
Ответы |
Re: Major Feature Interactions
|
Список | pgsql-hackers |
There's a number of major features all coming together over the next weeks, so I wanted to raise some awareness of possible areas of interaction. My concern is more than just "will multiple patches apply together?", but extends into whether the features interact with each other with synergy, ignore each other or have negative impact. The projects that concern me are the following internals projects Plan Invalidation Autovacuum changes Bitmap indexes GIT indexes Dead Space Map (DSM) HOT Updating Updateable cursors Restartable VACUUM The potential interactions as I understand them are these: I'm not saying this list is either complete or accurate; checking whether it is or not is exactly the reason for this post. Anyway, just trying to raise awareness to look for potential issues. UpdCursors ----------Syntax changes only, no impact on other projects mentioned. HOT --- GITUsed to be some conflicts at patch level, now gone?Positive impact on GIT performance PlanInvalheap_check_hotupdate() test can performed in planner, sowill no longer be a heap function DSMHOT updates need not be logged, since they will be clearedby retail VACUUMs BitmapIdxPotential issue with chilling tuples during CREATE INDEX AutoVacHOT will change how UPDATEs are reported to pg_stat, byadding additional fields. UpdCursorsShould tidscan follow chain to correct tuple? That seems tochange current behaviour even if it might be useful. Plan Invalidation -----------------No known changes, other than the integrations already mentioned Autovacuum changes ------------------ DSMIs implementing new forms of VACUUM: VACUUM and VACUUM ALL.Does reporting of row stats change? Bitmap indexes -------------- GITDo we need both? I think yes, but need to see some info onwhen crossover occurs between two index methods. Restartable VACUUM ------------------ DSMInteractions with DSM? HOTMust use full cycles only -- Simon Riggs EnterpriseDB http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: