tag:blogger.com,1999:blog-20038672.post4575083428859373352..comments2024-03-28T00:58:29.187-04:00Comments on Robert Haas: No More Full-Table VacuumsRobert Haashttp://www.blogger.com/profile/08393677427643988650noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-20038672.post-78912841816775250852016-03-21T13:26:30.793-04:002016-03-21T13:26:30.793-04:00This will help us tremendously. Those VACUUM (to p...This will help us tremendously. Those VACUUM (to prevent wraparound) processes are a big problem for us, not so much for any performance impact, but they do constantly get in the way of automated software upgrades that need to do DDL.Steve Kehletnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-45516610059692199182016-03-18T12:01:00.386-04:002016-03-18T12:01:00.386-04:00Great work, thanks for contributingGreat work, thanks for contributingLarryhttps://www.blogger.com/profile/10081543924948897705noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-29963672869206971772016-03-18T11:19:51.718-04:002016-03-18T11:19:51.718-04:00The sheer fucking hubris of this postThe sheer fucking hubris of this postAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-77260922785950462472016-03-17T10:52:04.794-04:002016-03-17T10:52:04.794-04:00The target audience for this enhancement is...ME! ...The target audience for this enhancement is...ME! Amazing, timely work, you continue to hit homeruns. I am in the process of designing/building/loading a large (20TB) genomics database, currently in v9.5 and one of my biggest concerns was the vacuum. I'm currently building the ETL to bring the data over from dozens of smaller MySQL databases.<br /><br />Our data is the exact model you described - huge areas of static data with smaller areas of very hot activity (as we write new genomic data or update a small percentage of existing rows). Thank you! I look forward to trying this out as soon as available...the timing looks to be very good.Mike Sofennoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-53075301941470065832016-03-17T08:35:26.484-04:002016-03-17T08:35:26.484-04:00Great work Robert!Great work Robert!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-65608860079153669462016-03-11T10:30:36.607-05:002016-03-11T10:30:36.607-05:00> wraparound
64bit per xid -- too many bytes> wraparound<br /><br />64bit per xid -- too many bytesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-82280134384541788812016-03-11T06:06:40.472-05:002016-03-11T06:06:40.472-05:00Great news, thanks for the work. Looking forward t...Great news, thanks for the work. Looking forward to forgeting about wraparound.vdphttps://www.blogger.com/profile/07836622731674773883noreply@blogger.com