Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCNVP-0004Rk-Sb for pgsql-admin@arkaria.postgresql.org; Thu, 22 Jun 2023 16:50:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCNVO-0002BW-Pm for pgsql-admin@arkaria.postgresql.org; Thu, 22 Jun 2023 16:49:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCNVN-0002BN-FH for pgsql-admin@lists.postgresql.org; Thu, 22 Jun 2023 16:49:58 +0000 Received: from mx0b-000e5c14.pphosted.com ([148.163.137.209]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qCNVI-0043Ah-8l for pgsql-admin@postgresql.org; Thu, 22 Jun 2023 16:49:56 +0000 Received: from pps.filterd (m0206230.ppops.net [127.0.0.1]) by mx0a-000e5c14.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 35MEt8cR023282; Thu, 22 Jun 2023 11:49:49 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=express-scripts.com; h=from : to : date : message-id : references : in-reply-to : content-type : mime-version : subject; s=pod140124231234; bh=EHAkEFJMcAHBtQnhR5d3jgBPpzLl+eQJXU+MwicY6mY=; b=Om+DL/dB9HKKNpo+dH0Js3frsbs5SwzmHcxv5Fc+BlmTTFIm3NcOnYrqCrNLDKhdyc2I Jf02TvLBwe+CjSsehwbjJm0aQ1TDZtS71kdbsHh8hfXzPxaO8cyvIunJYHhq2vjgpiJw OUhDB5BWcEYLs6bxIv5LH+O9EESNjpacmzvqB2YnqAio39n6PfLhdtee37GMNNaYQnxX HCPiOFNptaN3wVLH6YgQzGCRoyklIJzVGa6XY8rrJ01W5sAyP63cVg5UmfqgunOYSQAl 1oYzDGmD0rSxq0j7BZ88gPpij6ykYkCMwbkzjTRjY2RzTdqg9RbApa/p1TgKosEHUapm dg== Received: from eiaappxp0007.gid.prd.globalcore.com ([170.48.0.130]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3rc3mqjjj1-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Thu, 22 Jun 2023 11:49:48 -0500 Received: from cvlappxp20748.internal.cigna.com (HELO PS2PW1012186.accounts.root.corp) ([10.36.52.78]) by EIAAPPXP0007.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 22 Jun 2023 16:49:47 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012186.accounts.root.corp (10.221.225.154) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.26; Thu, 22 Jun 2023 12:49:47 -0400 Received: from PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad]) by PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad%6]) with mapi id 15.02.1118.026; Thu, 22 Jun 2023 12:49:47 -0400 From: "Wetmore, Matthew (CTR)" To: Wells Oliver , pgsql-admin Thread-Topic: [EXTERNAL] work_mem + refresh mat view concurrently performance Thread-Index: AQHZpSMM5M8RBv99Zku8TMisBdpqr6+XBxrQ Date: Thu, 22 Jun 2023 16:49:47 +0000 Message-ID: <8414ad71bc6d48c0864a944960b87aec@express-scripts.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.222.252.1] x-proofpoint-routing: 000e5c14 Content-Type: multipart/alternative; boundary="_000_8414ad71bc6d48c0864a944960b87aecexpressscriptscom_" MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: work_mem + refresh mat view concurrently performance X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.254,Aquarius:18.0.957,Hydra:6.0.591,FMLib:17.11.176.26 definitions=2023-06-22_12,2023-06-22_02,2023-05-22_02 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_8414ad71bc6d48c0864a944960b87aecexpressscriptscom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 TXkgZXhwZXJpZW5jZSBvbiBhIGxhcmdlIG1hdCB2aWV3LCBpZiB5b3UgaGF2ZSBwYXJhbGxlbCBz ZXQgdXAsIGRyb3AgdGhlIG1hdCB2aWV3IGFuZCByZWNyZWF0ZSBzaW5jZSBDUkVBVEUgaXMgYXZh aWxhYmxlIGZvciBwYXJhbGxlbC4NCg0KSXTigJlzIHRoZSBjb25jdXJyZW50bHkgdGhhdCBzbG93 cyB0aGluZ3MgZG93biB3aXRob3V0IHRoZSBsb2Nrcy4NCg0KSSB3b3VsZCB0cnkgc2Vzc2lvbiB3 b3JrX21lbiBpbiBzYW5kYm94IGZpcnN0LCBkZXBlbmRpbmcgb24gaG93IGxvbmcgdGhlIHZpZXcg cmVmcmVzaCB0YWtlcywgYXMgYSBzaGFycCBpbmNyZWFzZSBjb3VsZCBhZmZlY3QgbWVtb3J5IGZv ciBvdGhlciBzdHVmZiBvciBoYXZlIHNlcnZlciBpbXBhY3QNCg0KDQoNCg0KDQpGcm9tOiBXZWxs cyBPbGl2ZXIgPHdlbGxzLm9saXZlckBnbWFpbC5jb20+DQpTZW50OiBUaHVyc2RheSwgSnVuZSAy MiwgMjAyMyA5OjAyIEFNDQpUbzogcGdzcWwtYWRtaW4gPHBnc3FsLWFkbWluQHBvc3RncmVzcWwu b3JnPg0KU3ViamVjdDogW0VYVEVSTkFMXSB3b3JrX21lbSArIHJlZnJlc2ggbWF0IHZpZXcgY29u Y3VycmVudGx5IHBlcmZvcm1hbmNlDQoNCklzIHRoZXJlIGFueSByZWxhdGlvbnNoaXAgaGVyZT8g V29uZGVyaW5nIGlmIGluY3JlYXNpbmcgdGhlIGZvcm1lciB0byBhIGxhcmdlIGFtb3VudCBmb3Ig YSBzZXNzaW9uICgyZ2I/KSB3b3VsZCBoZWxwIHRoZSBqb2lucy9oYXNoaW5nL2V0YyBvZiB0aGUg bWF0IHZpZXcgcmVmcmVzaC4gT3IgaWYgdGhpcyBpcyBqdXN0IG5vbnNlbnNlLg0KDQpMb29raW5n IGZvciBzb21lIGdhaW5zIGluIHJlZnJlc2hpbmcgaWYgcG9zc2libGUuDQoNCi0tDQpXZWxscyBP bGl2ZXINCndlbGxzLm9saXZlckBnbWFpbC5jb208bWFpbHRvOndlbGxzb2xpdmVyQGdtYWlsLmNv bT4NCg== --_000_8414ad71bc6d48c0864a944960b87aecexpressscriptscom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjpibHVlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBzcGFu Lk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xvcjpw dXJwbGU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpwLm1zb25vcm1hbDAsIGxpLm1z b25vcm1hbDAsIGRpdi5tc29ub3JtYWwwDQoJe21zby1zdHlsZS1uYW1lOm1zb25vcm1hbDsNCglt c28tbWFyZ2luLXRvcC1hbHQ6YXV0bzsNCgltYXJnaW4tcmlnaHQ6MGluOw0KCW1zby1tYXJnaW4t Ym90dG9tLWFsdDphdXRvOw0KCW1hcmdpbi1sZWZ0OjBpbjsNCglmb250LXNpemU6MTIuMHB0Ow0K CWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLHNlcmlmO30NCnNwYW4uZ21haWxzaWduYXR1 cmVwcmVmaXgNCgl7bXNvLXN0eWxlLW5hbWU6Z21haWxfc2lnbmF0dXJlX3ByZWZpeDt9DQpzcGFu LkVtYWlsU3R5bGUxOQ0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZh bWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZh dWx0DQoJe21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtc2l6ZToxMC4wcHQ7DQoJ Zm9udC1mYW1pbHk6IkNhbGlicmkiLHNhbnMtc2VyaWY7fQ0KQHBhZ2UgV29yZFNlY3Rpb24xDQoJ e3NpemU6OC41aW4gMTEuMGluOw0KCW1hcmdpbjoxLjBpbiAxLjBpbiAxLjBpbiAxLjBpbjt9DQpk aXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rpb24xO30NCi0tPjwvc3R5bGU+PCEtLVtp ZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWRlZmF1bHRzIHY6ZXh0PSJlZGl0IiBzcGlkbWF4 PSIxMDI2IiAvPg0KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+DQo8 bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+DQo8bzppZG1hcCB2OmV4dD0iZWRpdCIgZGF0YT0i MSIgLz4NCjwvbzpzaGFwZWxheW91dD48L3htbD48IVtlbmRpZl0tLT4NCjwvaGVhZD4NCjxib2R5 IGxhbmc9IkVOLVVTIiBsaW5rPSJibHVlIiB2bGluaz0icHVycGxlIj4NCjxkaXYgY2xhc3M9Ildv cmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXpl OjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6 IzFGNDk3RCI+TXkgZXhwZXJpZW5jZSBvbiBhIGxhcmdlIG1hdCB2aWV3LCBpZiB5b3UgaGF2ZSBw YXJhbGxlbCBzZXQgdXAsIGRyb3AgdGhlIG1hdCB2aWV3IGFuZCByZWNyZWF0ZSBzaW5jZSBDUkVB VEUgaXMgYXZhaWxhYmxlIGZvciBwYXJhbGxlbC4NCjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxw IGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFt aWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEIj48bzpwPiZu YnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0i Zm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2Vy aWY7Y29sb3I6IzFGNDk3RCI+SXTigJlzIHRoZSBjb25jdXJyZW50bHkgdGhhdCBzbG93cyB0aGlu Z3MgZG93biB3aXRob3V0IHRoZSBsb2Nrcy48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTom cXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8 L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQt c2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2Nv bG9yOiMxRjQ5N0QiPkkgd291bGQgdHJ5IHNlc3Npb24gd29ya19tZW4gaW4gc2FuZGJveCBmaXJz dCwgZGVwZW5kaW5nIG9uIGhvdyBsb25nIHRoZSB2aWV3IHJlZnJlc2ggdGFrZXMsIGFzIGEgc2hh cnAgaW5jcmVhc2UgY291bGQgYWZmZWN0IG1lbW9yeSBmb3Igb3RoZXIgc3R1ZmYgb3IgaGF2ZSBz ZXJ2ZXINCiBpbXBhY3Q8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJp JnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+ PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7 Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0Qi PjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFu IHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDss c2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZh bWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+PG86cD4m bmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9 ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNl cmlmO2NvbG9yOiMxRjQ5N0QiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNz PSJNc29Ob3JtYWwiPjxiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5 OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZiI+RnJvbTo8L3NwYW4+PC9iPjxzcGFuIHN0 eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fu cy1zZXJpZiI+IFdlbGxzIE9saXZlciAmbHQ7d2VsbHMub2xpdmVyQGdtYWlsLmNvbSZndDsNCjxi cj4NCjxiPlNlbnQ6PC9iPiBUaHVyc2RheSwgSnVuZSAyMiwgMjAyMyA5OjAyIEFNPGJyPg0KPGI+ VG86PC9iPiBwZ3NxbC1hZG1pbiAmbHQ7cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcmZ3Q7PGJy Pg0KPGI+U3ViamVjdDo8L2I+IFtFWFRFUk5BTF0gd29ya19tZW0gJiM0MzsgcmVmcmVzaCBtYXQg dmlldyBjb25jdXJyZW50bHkgcGVyZm9ybWFuY2U8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj bGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxkaXY+DQo8cCBjbGFzcz0i TXNvTm9ybWFsIj5JcyB0aGVyZSBhbnkgcmVsYXRpb25zaGlwIGhlcmU/IFdvbmRlcmluZyBpZiBp bmNyZWFzaW5nIHRoZSBmb3JtZXIgdG8gYSBsYXJnZSBhbW91bnQgZm9yIGEgc2Vzc2lvbiAoMmdi Pykgd291bGQgaGVscCB0aGUgam9pbnMvaGFzaGluZy9ldGMgb2YgdGhlIG1hdCB2aWV3IHJlZnJl c2guIE9yIGlmIHRoaXMgaXMganVzdCBub25zZW5zZS48bzpwPjwvbzpwPjwvcD4NCjxkaXY+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4N CjxwIGNsYXNzPSJNc29Ob3JtYWwiPkxvb2tpbmcgZm9yIHNvbWUgZ2FpbnMgaW4gcmVmcmVzaGlu ZyBpZiBwb3NzaWJsZS48YnIgY2xlYXI9ImFsbCI+DQo8bzpwPjwvbzpwPjwvcD4NCjxkaXY+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+PHNwYW4gY2xhc3M9ImdtYWlsc2lnbmF0dXJlcHJlZml4Ij4tLSA8L3Nw YW4+PG86cD48L286cD48L3A+DQo8ZGl2Pg0KPGRpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj5XZWxscyBPbGl2ZXI8YnI+DQo8YSBocmVmPSJtYWlsdG86d2VsbHNvbGl2ZXJAZ21haWwu Y29tIiB0YXJnZXQ9Il9ibGFuayI+d2VsbHMub2xpdmVyQGdtYWlsLmNvbTwvYT48bzpwPjwvbzpw PjwvcD4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwv Ym9keT4NCjwvaHRtbD4NCg== --_000_8414ad71bc6d48c0864a944960b87aecexpressscriptscom_--