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 1rydQF-00HEop-Hy for pgsql-general@arkaria.postgresql.org; Sun, 21 Apr 2024 20:04:23 +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 1rydQC-00Fqm8-G0 for pgsql-general@arkaria.postgresql.org; Sun, 21 Apr 2024 20:04:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rydQC-00Fqlp-1U for pgsql-general@lists.postgresql.org; Sun, 21 Apr 2024 20:04:20 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rydQ9-002DkD-0D for pgsql-general@lists.postgresql.org; Sun, 21 Apr 2024 20:04:18 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-22edec341c2so2070917fac.0 for ; Sun, 21 Apr 2024 13:04:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713729855; x=1714334655; darn=lists.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=EIpFHp0Q4oBCZkSzHAhWajE0pNcA5xdQX5sdC7iy8WU=; b=Bp1eSrZdydCbI9wBkE8iA5qGEargBcHSvYbB31KKaft2W2w3vQKkrl9pEMb/xg5Bo1 yqQSSMoNCA1t/b8LiKbPeVHe8zfNOxMByjl06EW/IuCGu7e0RAnFYrHr9T7sKNmLQbrP hDVl8I2roKPAUzk9aqel2u1i3lBJ9z5pSJIVnN2i/BfCTnx2AGTl6r43CgS6+iZV3iFE 2v5Ux1nbvlV6VNoD/W+A0TKSVJTFr38HeUWHctBtdfjnfBKY8GG8pMJCsjy0+Z77mtzR HXizz11zCLmV6eK4PNGJqymsNiKN9GUzjcQ7CzyEwnE761dl5zhzE0Z4d3wak6EGbio9 Y8bA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713729855; x=1714334655; 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=EIpFHp0Q4oBCZkSzHAhWajE0pNcA5xdQX5sdC7iy8WU=; b=FoaMU8gPg5OkZLz3oazGHKJ/oCBWOlYSy0UuyhbysWfAXMnWugbXRuwI7cEtAXTnx8 rCpIb9RvBYsOyK59guLdvkxBIU86qlSXI2kw23Rb+MFJPy3n8GWDjpERd8uGePgqumbo vT/wFAdp1LH/k6rKkMpEWu3731ZMgUHKUkvpi0RdRE8sTxkUq553H5htJqk30ttR0RsE fQaA0tt5D/oNhA0vqwg9BpDR9GcM/4k9mE21e77xh6PGk3bxnBp/VzJ37oMftl+3Aiiw 7k5PBc9UajJBrd8QTDH5Jd7s5ogH70kXoWld7IW+ZLqipvXKmfRGE/jW/wPjgbKR9JQN KgPA== X-Forwarded-Encrypted: i=1; AJvYcCVakUGJNo0G2n+XzLjU/ybg3lu0o/MU6CfOwLjBFucKNAwzYvTlkXbGgw0YqolMnAQlHkHLH/Dla67fNhz1T7olC3FVoz+sA1Cz6D4jrO6rAiAh X-Gm-Message-State: AOJu0YyxjD6dCY2+mOh8YZ9PJXsUUrIjtZJmZiEfPEqfR5TO5UsIKAxe 7FTOhu4OIn9YUUPns/05U63KfYwWVNTig1h0oBMUEGjhK8awKUDxXJB7brYo//3PXPIfM8zLrrp Zf7E+YWia4yn7ZKkSzwW/VYxExjI= X-Google-Smtp-Source: AGHT+IEUC0hP5DzJT59AHcmfoKh7CvtWR92DVyJs59QElLYuyiLV7cldxQ7nhpc2wiF0dNGIWGREptcv2N2dirs3z9w= X-Received: by 2002:a05:6871:73a6:b0:233:5bf6:f154 with SMTP id na38-20020a05687173a600b002335bf6f154mr10119445oac.50.1713729854816; Sun, 21 Apr 2024 13:04:14 -0700 (PDT) MIME-Version: 1.0 References: <2720974.1713710606@sss.pgh.pa.us> In-Reply-To: From: Ron Johnson Date: Sun, 21 Apr 2024 16:04:03 -0400 Message-ID: Subject: Re: error in trigger creation To: yudhi s Cc: "David G. Johnston" , Tom Lane , pgsql-general Content-Type: multipart/alternative; boundary="0000000000003cc9510616a0d3ab" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003cc9510616a0d3ab Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Apr 21, 2024 at 2:58=E2=80=AFPM yudhi s wrote: > the partition drop from parent is taking longer as it scans all the > partitions of the child table > Does the relevant supporting index exist on the child table? --0000000000003cc9510616a0d3ab Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Apr 21, 2024 at 2:58=E2=80=AFPM y= udhi s <learnerdatabase99= @gmail.com> wrote:
the = partition drop from parent is taking longer as it scans all the partitions = of the child table
=C2=A0
Does the r= elevant supporting index exist on the child table?
--0000000000003cc9510616a0d3ab--