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 1qh2Fc-000mWk-1B for pgsql-admin@arkaria.postgresql.org; Fri, 15 Sep 2023 06:24:24 +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 1qh2Fa-00EJ5t-OL for pgsql-admin@arkaria.postgresql.org; Fri, 15 Sep 2023 06:24:22 +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 1qh2Fa-00EJ5Y-9Y for pgsql-admin@lists.postgresql.org; Fri, 15 Sep 2023 06:24:22 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qh2FW-004edB-J4 for pgsql-admin@lists.postgresql.org; Fri, 15 Sep 2023 06:24:20 +0000 Received: by mail-ed1-x536.google.com with SMTP id 4fb4d7f45d1cf-52f3ba561d9so3879353a12.1 for ; Thu, 14 Sep 2023 23:24:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1694759056; x=1695363856; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=68BNHHiMMotKNQdtT0x6AXgQBcz18ohaMyBxnCOzlfQ=; b=uyqsUx6OPhw7vp+AADkV6wDxzCsLYpNQVjTnEL0yw/ZuUfpBXUirXZLMJvgaHqo6WS Y0sJWhD9mD46m8XxNT71n1TpIXx2zIvilLmbrA3eEJozL9UFPtDlT4wjCtJghfsyPiNe GA8n85IXYo/yJWr1MBTHBCfdyMx6gABSjb7ga1Og2QBMDXEFHEehj9elM+4HX3p0iGxT Yurv4pjuAh2gdtlZFVWRgGf/CgyBWlh5MJb/O6gbRXlmf+8h+yarvRBh849ct+7lRP+Z lKD8RN3HwREzZL+Jq9Jd2Ke5je3t1bPHxVL3gL1AHh2v9Fa5nClG/Ocu7AvJFlMcmQc9 Ccgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1694759056; x=1695363856; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=68BNHHiMMotKNQdtT0x6AXgQBcz18ohaMyBxnCOzlfQ=; b=hSvZIGaqIi66z3qUtL6kWA4XjAKNANCPMTPf0ynlsMu01tQglsBHDw776UeNrzSXKL FaaTnF+8XUZfzlz6ii8YeOQ8DGrdLJwUjZZ7l99U7q9gHi8XigIQt/OVnWKq+CBvhB6d dhVqo6KgQGV5wFLtQT73j6I1UX7eqVCksHzLFX2yigqAl9JF15v8pY5d/hrTpicI1Xxb 87aSv/ftR7BBVXHPa/avaOQXD8NUMl1pVavSXM6qBVqjNi/CDbl7G6S39bMehwOefKyS bMrZztk1/IXIz+KKi/lpwQ2ZNgCXhUVATFL8M47Idh3P/ZibujRr2zBqcMVr0ARqvjXx 8GLA== X-Gm-Message-State: AOJu0Yx3IHh+fYxxEB8dqLH9Sb03y3sLp8gJnn4hwTAF3oDH+NEN7AX/ DsiBdk25nqqxDLr5Lupn9qKHZA== X-Google-Smtp-Source: AGHT+IEXc6LM3oYT1FKdO4d9nMl0ZkGO7ICLXrPu8OQyVrH4aH6yzC+kfMoFd4KBQhsK6Fq1Hap+QA== X-Received: by 2002:a05:6402:27c8:b0:52c:f73:3567 with SMTP id c8-20020a05640227c800b0052c0f733567mr5180445ede.13.1694759055604; Thu, 14 Sep 2023 23:24:15 -0700 (PDT) Received: from localhost.localdomain (62-46-253-72.adsl.highway.telekom.at. [62.46.253.72]) by smtp.gmail.com with ESMTPSA id d16-20020aa7d690000000b0052a3aa50d72sm1800106edr.40.2023.09.14.23.24.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 14 Sep 2023 23:24:15 -0700 (PDT) Message-ID: <259e9e2e3cd53d95f728854e14b1856a56a8d916.camel@cybertec.at> Subject: Re: Blocking queries on a hot standby? From: Laurenz Albe To: Victor Sudakov , pgsql-admin@lists.postgresql.org Date: Fri, 15 Sep 2023 08:24:13 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2023-09-15 at 04:30 +0000, Victor Sudakov wrote: > Can you imagine, at least theoretically, any kind of query on a > physical replica (hot standby) which would block other queries on the > same replica? I cannot. Yours, Laurenz Albe