Content-Type: multipart/alternative;
 boundary="------------wpWBst8O1W0L128094nI4mCS"
Message-ID: <918deb54-9d01-4a9c-abd3-d8412c9e6c80@gmx.de>
Date: Mon, 9 Feb 2026 02:17:59 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgsql-general@lists.postgresql.org
From: Dirk Krautschick <dee-kay@gmx.de>
Subject: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on
 table
UI-OutboundReport: notjunk:1;M01:P0:+hoHy8w4lSA=;TpI27GPqOjP8t3n4yOpnj2uLpIT
 E+3v6amvCvhcoNZNnLQcW/uev4KvkCIpBY3/BfyXfjSfA71EkNvsPhnaoE+zEJEfg1JXmgA5i
 UcwC61xPq2pyBH46zLBcGcef7nhakFF9ksV/jPItWDUM/IoGXqlnxHpMchcVcJfHmZWUH9UFG
 1gm0+JQDDY4djjW/2duB1Ttnkrg9Ak8xtJmrwWbuD1BWETkikSKXNzlDMD0Zan5KztN7xdPcf
 WkXeufmwsGt0vNhUU9tPn54a1qUUu2vsejL9dC6Lzx/2RLdNO+SQcUpwQukKm9mYiOAQ8781D
 xChSm0/07wzifY7Th7ga2WVam2lJXM4s3aMqMSce+5JoqE2QiPx4lfLnWSfU/R82P1pEm88SN
 we1Xx4qY/Rr+I/fAWQWiEa6uCTIFelEAx4ihOYxBYpjS0eTBar6wpNQapCVIXgqpPRVNCwRR5
 xWE8xv6Uff+mFscY3Hx8JopUD3xxRDnp351+MWllHkSYrl367YACRxYFICDff/WXIW6RBWZWN
 lM+PZXI9CwjhEXqOEgHQwDVc4LMSEbZGno9ZSDvXEtxeBMspQv/jcryG4UXcjz+iFcGKMk2Tr
 /crtSOOkyIqP2fxtDNif6AdPeZByzIQ2cnwcpS5oOL6zZDY34XYtTW8wDy/V566DxyFAKqojO
 Ty+0A1Fk7BJdIcXN1TQ4p38NwnY8dAWOt4A7J1iLefPhyBND/wbcItj53aFK10t8SPU9M8z5r
 YF3zoNRIhKGCfX2urb1BQf49Xna7HTC2Xvh8oXBgGXDcvEqxPX/9LRl6J+FKVKw2LZlb+Nrfx
 4u7fjwhq09ehvlhgwi1/xI7ilQj19SnJByzXZs7uc8BsCfiL3uRgbaFSA0LHb+aWdTylDuUua
 NelR1GrPM0r99FcgbMkLS+zjAfRed+P2jtfxcHxKaH9SgAor4rqaS+ZEcc4SQlxlj5lrSXZAu
 mM8hGJzotDQTGsPCf3vqEyFqs20J2QNbbRu5nBda/8YXdz00JPtQezI9kJAYvUsGevhU7xb2G
 4YkPiE/8JCTj0x5sktWwV7dJy7r5YinEAqnTnbKnEOeKhNgnF2naQMllvKD+PYTwrZnlbN1vm
 DMuJEBWLbtrzrwmxh3bd27wLqswu46Yu224yAwFoTbg+VCI2kxWTEs7gXd/8u3C8dIyySrG3x
 f7iGKkGJ/bMoypta1BarSOwhkK5ZVcW78/Zx8OtqnGtm3mz3nNdikIGH7ej4vSHGsNgeETYNC
 B5TMdrdVn+wpHM2lxQg2R/S3v576OVS12MHjdl+te9U8fU8ZhxJ5Y+x/HvgCyg3xgYaoRbuZ5
 yaA+jZ7n9/8IP1SoeR1qj54b2W7+MnP1MGXo/7ru56c4msX+mp3cX3vsnICsCZ+ZlqVTAQ/tJ
 DYpIujCrJ0l+LGfkhtuw8Hi0l4LggbClqu8DY9biZGmLonPBvSK6IIDiZ85q38K93Ag/IhnIz
 AsYS21pzsraeCXKwGDMP/CaxvxjQp89Hh7h41psegIgaMf25sLVMeYqJRk5J0T3qBlQb4jJDQ
 1lvBAKDfJShPWhDnIl7r0uerjq2jXgRW9okU89IP6GZAVZL2M9Tm1Ft3lNXjJMiR66UfP4F6i
 OQ1EunNckrXZ23hVoVB707Tu9aN66xHSafj4V/I/ZO5CJibdrXaxfdJ16ECCoacgAK5/dVESF
 qm/iHaNyDT1LJHYJsKs8hHzjv2kgrkXkmQdXR939f7xndETGVduJf2IqZIxZTihqnDAerIi3B
 PEebGZr0f2ttZmgHYPadmhCTQngWDscXhpbsJc6EyPYQapb5EfSMtZpCD+EBDB2CH6e/sTVjS
 2XH5mmz0IzKgi0db0ryUd327xGWYHTJW5kRgkQY4uV71Ze1pr9LTDOsz3oBobx1EX1MjHe9wl
 l/b4qqivsdaxW2FtJd7AJ3G1l1cGX3RcaUQw00edM30fOoRTKFpmdwVGtghBUqye5SslJK215
 Y2tJamA8VX5CSK4iR6WChR68CFsZCGAezwl4+blYZoRzy1y5ux7VLnUf+4K5FAH0DOHvRB82R
 k6d0XLXvL01fPzNbpoMeeXmowGrTai6RIwK61Os1TYv9xANIb+HmNqZfVATyPoYTluHjEuBEf
 zuY2TWXFEpQX/aLWUUGCXNH2tcF/rKGCOnNBlxaNRunb4dHY4Ts7ap00ou0lWZMt9whKU2Jwu
 S15QanSWg1jx2CD23E8IYSd1hZ7cW90ibtgJDK6leWp8aRT7KlH7NYFiqLBaHmVePit3FgSU2
 BrPFCvG85W/cYLA5YWw3ybvEjwOkibQixKQAobfBbU1J+jQdXQgPa+VL7X4Wb3arM+HKcF1rx
 +zMjB+XOsqRHhiM/A884kXlWS0OE9iA/o2u150HBs7+yMzAXihiJhTTuE/5J+07SmfkNit6qe
 tnmQq06WkWHJbwCXId0SbNfWixFFNag0TQLk5PPp/7U+GX8Y99j298tbwfkv9wnSpK41Zy2Dc
 1vDzjSD/B11LjeoBAPVhcIqsYMDDs6HhfHMCvdh9Id72JSRXHJSxtnEU7q3zbFUevk03dA+/p
 J48cF928sB39urIxkSKACnAZtS16EyeIzU/uzKp2qxi6se+5bOpIGxatOJJyt8lqjfmMyQYrb
 /WBTWIOYQbHIvqiFfArCWhxkEeEkBEficQAm+Opb8lW7FGkO7390X+TQmZ++jwvPZ4RM30n1+
 TZrFdLsQc8lmJKLg/9Q5o6BCm5yT4hiFdZ7Aredot/G7x76VJKpcY1xe/UL+q/IGuh0xJ9WjY
 fzjQE+boBeobD+52w7seSuuwFtnj7EdBpRsQVkKKPoN/GKgXZCifnRhnESQ34wmZjPH/u243F
 yU3kU/DkwQX+34vVfXDcCVk6j/ps5O9MLiM+r3b1R9UQ61IC2ph/LnIFsSCMdGO6ax47eC0m7
 0Dfsc5+hZoKN2FHqt7KTR/IOLVBttXmmttH0AHRhLyJL7ws2ZsaEMLSGdkhbB4k3ZS4ho8O2i
 VBCNwdcJpqTgNk169Jc35Z0q/uU5AlR8eCOQeYMZRCLIQ6IEzchdoSOiQsthQIVirS33GU5yi
 fb1YY0O+4LcKnyZq9c2w/Y7LD11zzXww/K2a7QQOkySLeqB0cC3hGOiqSav5nHpNrF5Jfo0v9
 XfhnKplAXrpOruSpLMAri+fqnzl5Kai4dIPxDLIONakyMhYi7DxGVjA5CPYCuqCPsfbgcvoco
 HI0uomGsoV/zecvNyo8+wTwUJ9H5s0E37Y+03lNZ5cTNfcJ31Wi4HBc4AoeJT/6Vri5gSMWKC
 wPYSFX+i40ECCfxoczOseTz8XQMxZD+aPWqMXCkiDfDuITNtOARxuV16j36huPOLyuzwdENnJ
 Z/E2HD8C6WctRkbRm2EHD/Fi+zzAoq4f6ffdcoB3r9gC53wt9fEXj9XFll2CGlaV3rzW9bSW1
 Bbs5ib0w/Ft1z/pGmfAMdfa26txX6Gokt+7pucg58YbnsbJUDY5nZ2hKofYZoi0GnWq3Jd+tP
 wjZ4qkdW8t6LZHGBqbgsBdZJjLmkKPVbdAoVEhIUsmSgVdjSZDShZom5iyWLBVadbJcY2Q8qa
 nF7ecVQ9PEogXoHTWtpLbRfMErjQ6AJAlQZoamTGV+Sv4zkuhHiGj7ecpu/ucKoCV+6LOAfsW
 1rMyILRbHS5oSqEWhSESZYKt0hIMfYdXr9WcRu1fJy7459a0PjEmNegxnayVC1VxmuPDwGXNG
 4hcQyhPoRp0JVPca2WmJ9OfcWQBVtAR7hq71PQ8QMkkqRCAeeufqDp53UZz6s/fpWAI67DE4z
 knyaNF0q4dS+pkfM0TO2ZusL2QFTlErba5Phmd0ZixABUggAZsiOmcVQyoDmKMzqR6seHO9Pr
 FZew6pS5/llYUdNlv6hc+YdIhx7rQ+e5/oqgOA2HACsZQP8r7HfvlmHv/ixKygq0o/2hfLzO5
 3hjmCgdWf8kH/KMmzZLMKXtdlZdirKj8SghR9DeRETcoC6XbbGuWTCoasctcw0hSg0e9/CmwX
 aLMzEVTomc8RZ1Ys0WvGS5FyblTMknw71pCihxITEB6E8kBkhNpsv4cTtWAgSr5vaGufjWxoQ
 i07oMZAJck1qrNQY7X3hpcFSby7NB6f90+0IsKjevKcpl5wfvddo8kyCGen5sGBCSUViFAJ3o
 0vuNiouDju7ujFT8f0ZseNA2Mr2XnIo6zr8Vjm7mf/JMaowSqwefksdqHPSlwcwZf0bECMH4l
 xqUPmKHNA6bwzB1jppSZmvASYePeopZoroWLO4fuXDDg1RvTQAuy3xahhNTcuJaKZtl1rgL5R
 KlZr8y0U1nBaH8Qg7Wplcwe4pjAou0v0tC/+eQwIToUwWEuMB81N27Kwp5WYz24R6NTDP6kzc
 PELPFB2qfqxZmF7BF2ovR/6tdQZZaTqaYf4rhCuV0uUMP7Bxidm2ffmfqPiVHvqmVl1V5jHG4
 BTvjv39hvOJYqTjOC64BnoeAAUZmAErrXpxb9h00md1ZE/b7MkC90/3AieoLxaGFzWjrTtdUX
 ylERO7VDpWXa19C/gv2FlpAZ6WZngwSdoL9/8tmbaVzJFYKCRSIwxgOofS2J3LKeT6+mKHHV6
 P3LQYR3zCBCAsl7WxJzcQjAw7HI3C17Ct4DzSFrHou98g6RB2dGak/JIQ0JHnMZQuPPR456tb
 TgwUrDTmU2KzOSjkyE0bOJl/GCJSTIPGEl0tVhlfQQBN2GFKnci4FHoZaeNts7E3ZCSoJWxtP
 NiDJq/sKcBtKjnBFMaQAQa/2hpDInnRB3FK6cVYirl/7x5273AOcGYC+QRNGLk0OtStqxM/Zk
 20JK+D+7nNgs0zKf7Y1lSjKhIfoNVKWSmJHnIw6ZUHMJ7HdynHdpsdQkx7YNfVlrEGmp4zLH7
 dsuiI4EidULIHngBIEETxfFtFLB05214/cEb5LhAbOEbv7LXB3mRJo7TgWfzXdLsa/2MbwbwB
 WV4Z5mqOAOw0vrinZx9YEzlEH77Za6Pov5jQvTvte484b2iUFMxM1sIeAcKC8HCDSQrrMBtXv
 Hj6Mt3S5s/RVOw7Rlje0KQUaSmCZAqkaMh9WkqVInRB2d5aGTd3/eZJJozApd4C9HR6jmu3dI
 tfTPUELpK/wB2AGafROxxufBD9JnQVBZCwomDR27xhBuK4EmmorN9e6EtRZQu/w9FRcRdhm8t
 rgVMfvmIaBbwG9Rrn2rBnDt55Mip45kDoLuNB/937iql8PdImS8ZYN4Jg+a/VjMP0OFT8Z2Zk
 R0VHSIPJ5GgitToGArvLfnxMQUjPjRBVZ4Czxd9fU4jY26TDtW7uWMgNcQN1kKK0PgFj1SI8j
 AqnK5ii2C59xupiYZ22G
Archived-At: <https://www.postgresql.org/message-id/918deb54-9d01-4a9c-abd3-d8412c9e6c80%40gmx.de>
Precedence: bulk

This is a multi-part message in MIME format.
--------------wpWBst8O1W0L128094nI4mCS
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi,

I have a situation here where a frequent

REFRESH MATERIALIZED VIEW CONCURRENTLY

is preventing autovacuum on some tables kind of running into a circle of=
=20
growing.

Why is this acutally blocking autovacuum and what is the best practice=20
to prevent
this excelt just not refreshing the materialized view frequently? :-)

Cheers

Dirk

--------------wpWBst8O1W0L128094nI4mCS
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DUTF-=
8">
  </head>
  <body text=3D"#000000" bgcolor=3D"#ffffff">
    <font face=3D"Helvetica, Arial, sans-serif">Hi,<br>
      <br>
      I have a situation here where a frequent=C2=A0<br>
      <br>
      REFRESH MATERIALIZED VIEW CONCURRENTLY<br>
      <br>
      is preventing autovacuum on some tables kind of running into a
      circle of growing.<br>
      <br>
      Why is this acutally blocking autovacuum and what is the best
      practice to prevent=C2=A0<br>
      this excelt just not refreshing the materialized view frequently?
      :-)<br>
      <br>
      Cheers<br>
      <br>
      Dirk</font>
  </body>
</html>

--------------wpWBst8O1W0L128094nI4mCS--