Re: Performance degradation of REFRESH MATERIALIZED VIEW

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Paul Guo <guopa(at)vmware(dot)com>
Subject:	Re: Performance degradation of REFRESH MATERIALIZED VIEW
Date:	2021-06-03 23:30:55
Message-ID:	106582.1622763055@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-03-11 08:44:37 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>  2021-03-11 18:13:39 from Andres Freund <andres(at)anarazel(dot)de>   2021-03-12 04:32:24 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>  2021-04-12 06:20:41 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎   2021-04-16 03:16:51 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>    2021-04-19 04:32:31 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>     2021-04-19 08:04:04 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>      2021-04-19 08:27:11 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎       2021-04-19 11:03:58 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>        2021-04-19 13:51:09 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎         2021-04-20 02:04:43 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>          2021-04-20 05:49:59 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>           2021-04-20 06:55:25 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>            2021-04-26 13:31:02 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>             2021-04-26 19:27:46 from Andres Freund <andres(at)anarazel(dot)de>              2021-04-26 21:59:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>               2021-04-26 23:07:17 from Andres Freund <andres(at)anarazel(dot)de>                2021-04-27 05:34:43 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                 2021-04-27 13:43:07 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                  2021-04-27 13:53:32 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                  2021-04-27 14:03:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                  2021-04-27 15:26:02 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                   2021-04-27 15:44:47 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                    2021-04-27 16:24:14 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                    2021-04-27 18:22:36 from Andres Freund <andres(at)anarazel(dot)de> 📎                     2021-05-05 13:04:53 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                      2021-05-11 07:37:13 from Michael Paquier <michael(at)paquier(dot)xyz>                       2021-05-11 09:04:06 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                        2021-05-11 10:58:23 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                         2021-05-11 13:58:20 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                        2021-05-11 14:07:44 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                         2021-05-11 15:56:33 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                          2021-05-11 17:32:05 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                           2021-05-18 02:20:07 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎                            2021-05-18 18:08:16 from Andres Freund <andres(at)anarazel(dot)de>                             2021-05-18 18:43:41 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                              2021-05-18 18:57:19 from Andres Freund <andres(at)anarazel(dot)de>                             2021-05-19 02:56:40 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                            2021-05-18 18:34:08 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                             2021-05-18 18:44:30 from Andres Freund <andres(at)anarazel(dot)de>                         2021-05-11 17:25:00 from Andres Freund <andres(at)anarazel(dot)de>                          2021-05-11 17:35:23 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                           2021-05-21 16:17:01 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                            2021-05-21 16:43:44 from Andres Freund <andres(at)anarazel(dot)de>                             2021-05-21 18:10:13 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                              2021-05-24 07:53:10 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                               2021-05-24 10:37:18 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                2021-05-24 18:21:19 from Andres Freund <andres(at)anarazel(dot)de>                                 2021-05-24 22:30:13 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                  2021-05-30 22:15:21 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                   2021-06-02 23:02:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                    2021-06-03 02:56:19 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                    2021-06-03 23:30:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2021-06-04 00:48:05 from Andrew Dunstan <andrew(at)dunslane(dot)net>                       2021-05-11 18:23:08 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                        2021-05-11 18:46:35 from Andrew Dunstan <andrew(at)dunslane(dot)net>                         2021-05-13 02:12:43 from Michael Paquier <michael(at)paquier(dot)xyz>                          2021-05-13 02:16:39 from Andres Freund <andres(at)anarazel(dot)de>                         2021-05-13 02:47:31 from Peter Geoghegan <pg(at)bowt(dot)ie>             2021-04-27 01:47:08 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: Performance degradation of REFRESH MATERIALIZED VIEW at 2021-06-02 23:02:17 from Tomas Vondra

Responses

• Re: Performance degradation of REFRESH MATERIALIZED VIEW at 2021-06-04 00:48:05 from Andrew Dunstan

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David G. Johnston	2021-06-03 23:53:08	Re: DELETE CASCADE
Previous Message	Tom Lane	2021-06-03 22:56:55	Re: checking return value from unlink in write_relcache_init_file