Feedback-ID: i76984098:Fastmail
Message-ID: <7f97d4a8-1f3f-47b1-8c42-5e0b8c46d467@aklaver.com>
Date: Thu, 26 Feb 2026 14:11:06 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Issue with refreshing materialized view from another system
To: Michael Nolan <htfoot@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAOzAquKm3DzMA3bdW5obh+ZWjuFJ=y9n4Wg7d=qFfkOXf0tHoA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAOzAquKm3DzMA3bdW5obh+ZWjuFJ=y9n4Wg7d=qFfkOXf0tHoA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/7f97d4a8-1f3f-47b1-8c42-5e0b8c46d467%40aklaver.com>
Precedence: bulk

On 2/26/26 1:59 PM, Michael Nolan wrote:
> We have a connection from a PostgreSQL server to a MySQL server which is 
> used to update a materialized view on the PostgreSQL server from tables 
> on the MySQL server (running CIVI-CRM, which may not be relevant.)
> 
> We are trying to move the PostgreSQL server to a new cloud server.
> 
> On the current production system, all the materialized views work, but 
> the biggest of them can take about an hour.
> 
> On the new system, the smallest of the materialized views works, but the 
> larger ones all seem to time out.

"... move the PostgreSQL server to a new cloud server", where is that 
relative to the MySQL server compared to old Postgres server?

> 
> Could this be some kind of setting on PostgreSQL, like a memory or 
> buffer issue?
> 
> Mike Nolan
> htfoot@gmail.com <mailto:htfoot@gmail.com>


-- 
Adrian Klaver
adrian.klaver@aklaver.com