Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tzYi7-003Zqt-No for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Apr 2025 10:19:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tzYi6-000TrU-EW for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Apr 2025 10:19:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tzYi6-000TrK-53 for pgsql-hackers@lists.postgresql.org; Tue, 01 Apr 2025 10:19:10 +0000 Received: from mail-lj1-x229.google.com ([2a00:1450:4864:20::229]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzYi4-002JgQ-1E for pgsql-hackers@postgresql.org; Tue, 01 Apr 2025 10:19:09 +0000 Received: by mail-lj1-x229.google.com with SMTP id 38308e7fff4ca-30bfd4d4c63so51521071fa.2 for ; Tue, 01 Apr 2025 03:19:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743502747; x=1744107547; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=8McGpKLCw3iLCLdoZ3/XrsznzRhCpVNiCZ40mstHtsQ=; b=l7pd93YWLsPqQnO6EhB0uIcAy+xmzSbA9PuQ7EbjbIzjFCP+JP7JzHWE61FKroD+0h XgEgRRjv5vQHo2dNb3eND3/8MxvfzYssAaSdqjybuQ5UopOZ8bTfvBcPeAt4kKwRfmt8 gMStiZOVK7wTOCcbyY3PIo1nzKTmL3HH7wlfDJy1L36aBRv4z2QSE9HUXKlDMWuM5n+o NjjbI847WNRwKbFVAIAubbbZEBXe8Aye1KI6b2gYe7aazg1DeHSBWvN/ZYLgymZE4/Mt TiKEaRqFk9SbDaOoBOeDbzBo+5AqVl9qLhAqj3ZBm2A5vc/WS3QgghDJXouB34XMdJ0D KJ2Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743502747; x=1744107547; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=8McGpKLCw3iLCLdoZ3/XrsznzRhCpVNiCZ40mstHtsQ=; b=RPZRnqcbXuJm1WnqVtWYTHcf4x3vcqvIHF48qU/3zW4fxJgaXfEzqPB90PNLuCocaM 6IYcu4oaVH3qfJ0BmiEhOOmXeVqjQ3BCqEm1b8k0jfFsUufrB46bv+9cm1360KRAEoNs kLf9RbjQpNKldRAK/PGPPiFefqjlDEy4fVDzo7S50lpupQ/TnTjMZF3b5N5RwBvVlnFJ TqnDaNZZ125AkUU3k5ojs2QSy741Qd/w/hyFdMDwyiLDzqIbpAJsOs+K33j4w/BfBUjc aF0WpXFR+vwx07adnnW72gIa492Gi1IB3ZHuYS/hsHI+ip5NKqJtZnmkg5ESdqTbSTS6 Nrwg== X-Forwarded-Encrypted: i=1; AJvYcCVJtx3Lu4fPfRbfFoDS9hKKh/qc4q73msg6wECwzazZjhXDX/grLjk7jVHsWiiyRBQzGCQblteRiM5XWf31@postgresql.org X-Gm-Message-State: AOJu0YwsZSawAgCAnAivWaaFvaSUCOqBz5i4i1D2Al6Xo6KpLqC0T53P QyRNHtNjc+QNbCHNjAD80x+jepr15C5JWiNC/TbLjIUHBzZWD4h7nB+nqRJNGg3Y0vWIkEZLniP 3G2K3goAjLgvJo1I3bbjgX+hjMAM= X-Gm-Gg: ASbGncsaaz4/ZludkvcWp1UsRPWoeu1cUiOF+HqZu5kw9vAwGKvrN+zWuaJXqA34LFA m5iU9sRRihbfeNgTWPQcXSXp57ErsLEeT/jia62nEPEtNRKQn92DdnqyEG3BcQlj/mlt69TWQMy TpE6QLwr9jzGhKX8xoIWn+sKk= X-Google-Smtp-Source: AGHT+IGAWjsSsnKguiJbxWVcBqKjM94rsi4G2goDzlAVZR+rv18l14l38MdPYIpglhxxLRF58PlR4pQnDQVhJSvTBys= X-Received: by 2002:a2e:bd0d:0:b0:30c:4be7:1d42 with SMTP id 38308e7fff4ca-30eecd2bfa0mr8158851fa.12.1743502746370; Tue, 01 Apr 2025 03:19:06 -0700 (PDT) MIME-Version: 1.0 References: <442e62f7-ef64-4df1-8453-d682fe9bdaa3@dunslane.net> <425ebe4b-06c5-4212-af68-fd0e5537c250@dunslane.net> In-Reply-To: From: Kirill Reshke Date: Tue, 1 Apr 2025 12:18:55 +0200 X-Gm-Features: AQ5f1JpDxvmMKJ3YVwNhrVMH75-IoJpZOmc_AohtxGFvc6HeIViuhCI1MxVRym8 Message-ID: Subject: Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). To: vignesh C Cc: jian he , Fujii Masao , Andrew Dunstan , "David G. Johnston" , PostgreSQL-development , Tom Lane , Michael Paquier Content-Type: multipart/alternative; boundary="000000000000dccbd30631b4dd54" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dccbd30631b4dd54 Content-Type: text/plain; charset="UTF-8" On Tue, 1 Apr 2025, 11:45 vignesh C, wrote: > > One thing I noticed was that if the materialized view is not refreshed > user will get stale data > > Should we document this? > Does this patch alter thus behaviour? User will get stale data even on HEAD, why should we take a care within this thread? > --000000000000dccbd30631b4dd54 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, 1 Apr 2025, 11:45 vignesh C, &l= t;vignesh21@gmail.com> wrote:= =C2=A0
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">
One thing I noticed was that if the materialized view is not refreshed
user will get stale data

Should we document this?

=

Does this patch alter thus be= haviour? User will get stale data even on HEAD, why should we take a care w= ithin this thread?
--000000000000dccbd30631b4dd54--