tag:blogger.com,1999:blog-7476449567742726187.post2444801927253478496..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: Determining your danger of multixact wraparound corruptionJosh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7476449567742726187.post-56021966603014565702015-05-31T22:51:50.186-07:002015-05-31T22:51:50.186-07:00Well, if you're running 9.3.7, it fixes that i...Well, if you're running 9.3.7, it fixes that issue, so you don't really need to worry about it. 9.3.8 will fix some other issues, but it seems likely that 9.3.8 will be out before you hit them.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-39855925391885307152015-05-31T00:55:35.516-07:002015-05-31T00:55:35.516-07:00For me - I'm not sure.
# ls -l | wc -l
37...For me - I'm not sure.<br /><br /># ls -l | wc -l<br /> 3730<br /><br />And new file is created each 5 minutes. Also look at this:<br /><br /># ls -la [A-F0-9]* | awk '{ print $6 " " $7 }' | sort | uniq -c | sort -n -b -k 3<br /> 113 May 9<br /> 181 May 10<br /> 200 May 11<br /> 196 May 12<br /> 203 May 13<br /> 230 May 14<br /> 177 May 15<br /> 130 May 16<br /> 153 May 17<br /> 166 May 18<br /> 157 May 19<br /> 204 May 20<br /> 60 May 21<br /> 151 May 22<br /> 139 May 23<br /> 144 May 24<br /> 224 May 25<br /> 166 May 26<br /> 191 May 27<br /> 209 May 28<br /> 186 May 29<br /> 132 May 30<br /> 17 May 31<br /><br />When this files are going to by recycled/removed/whatever?<br /><br />And I'm running 9.3.7 already.quakerhttps://www.blogger.com/profile/14847737910699464897noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-85871054168704004492015-05-28T05:19:00.326-07:002015-05-28T05:19:00.326-07:00I think I'm OK ;)
[root@supernews:/usr/local...I think I'm OK ;)<br /><br />[root@supernews:/usr/local/pgsql/data/pg_multixact/members] # ls | wc -l<br /> 1<br /><br /><br />[root@supernews:/usr/local/pgsql/data/pg_multixact/members] # ls -l<br />total 8<br />-rw------- 1 pgsql pgsql 8192 May 23 22:35 0000<br />Dan Langillehttps://www.blogger.com/profile/16503965175456595456noreply@blogger.com