tag:blogger.com,1999:blog-7476449567742726187.post7800801925556881899..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: Freezing Your Tuples Off, Part 3Josh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7476449567742726187.post-692603089315572032015-09-21T18:46:19.205-07:002015-09-21T18:46:19.205-07:00Actually, that is exactly what freezing is, it rep...Actually, that is exactly what freezing is, it replaces the original xid with the special frozen xid.-dghttps://www.blogger.com/profile/01187206223217812827noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-90506754766787566602015-05-12T09:53:46.105-07:002015-05-12T09:53:46.105-07:00Josh, thank you, great articles! I would suggest f...Josh, thank you, great articles! I would suggest for future googlers that you add a link to your new article, [Introducing Flexible Freeze](http://www.databasesoup.com/2014/10/introducing-flexible-freeze.html).Steve Kehlethttps://www.blogger.com/profile/07568850497983767709noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-67878819639825051552014-12-12T07:24:58.832-08:002014-12-12T07:24:58.832-08:00Couldn't postgres reserve a special XID that i...Couldn't postgres reserve a special XID that is never available for normal transactions but that indicates that any transaction can see it because it is so old? Then instead of constantly having to freeze old XIDs each time the XID is going to wrap, vacuum can just set it to the special XID and never touch it again unless something really changes.Brian Krughttps://www.blogger.com/profile/12811343577920125094noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-393018227959976612014-03-25T20:30:49.062-07:002014-03-25T20:30:49.062-07:00Nice article! Note there are a couple of places wh...Nice article! Note there are a couple of places where it refers to "autovacuum_max_freeze_age", when in fact the setting is named autovacuum_freeze_max_age.Anonymoushttps://www.blogger.com/profile/17869788952342173080noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-17914863548155693262012-12-11T06:31:44.298-08:002012-12-11T06:31:44.298-08:00In the first paragraph, it is the visibility map t...In the first paragraph, it is the visibility map that controls what pages vacuum checks, not the free_space_map.Bruce Momjianhttps://www.blogger.com/profile/07875088787463864011noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-60568175759386930692012-12-08T12:15:25.762-08:002012-12-08T12:15:25.762-08:00Meant to add to the previous comment; thanks for t...Meant to add to the previous comment; thanks for the tips. The post clarified some things for me.Adrian Klaverhttps://www.blogger.com/profile/09632095365606250299noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-60225516985061985572012-12-08T12:11:14.746-08:002012-12-08T12:11:14.746-08:00Maybe it is just me but is there a query missing?
...Maybe it is just me but is there a query missing?<br /><br />"During expected "slow periods", run this query to get a list of tables:"Adrian Klaverhttps://www.blogger.com/profile/09632095365606250299noreply@blogger.com